# Presentation: 933206

## DB2 & HPSS – Managing DB2 Data with HPSS

- Using HPSS VFS
- Dave Boomer

- Template Documentation

**Notes:**
To replace the title / subtitle with your own:
Click on the title block -> select all the text by pressing Ctrl+A -> press Delete key -> type your own text

## Agenda

**What?**
**How?**
**Why?**
**Other considerations**

- Template Documentation

## What?

**Store “live” DB2 data (application data, not HPSS metadata) in HPSS.**
**Ensure the data remains available for SQL queries.**

- Template Documentation

## Why?

**Amounts of data have been steadily increasing.**
**Large amounts of “seldom used” or “old data” affects overall database performance.  **
**VFS Containers can be targets for data archival. **
**DB2 data remains “native” to DB2.**
**Minimize data archival process overhead.**
**Archive data is accessible directly via SQL.**
**Appears to client as “normal” database data.**
**No “middleware” needed to support access (ex. No custom federation code required to see data).**

- Template Documentation

## How?

**Define Tablespace Containers on HPSS VFS.**

- Template Documentation

## Slide 6

- Template Documentation

## Slide 7

- Template Documentation

## DB2 Using HPSS VFS – Where are we?

**First working example:**
- Created “SAMPLE” database supplied w/DB2
- Added an SMS tablespace with container def on HPSS VFS.
- Added a DMS tablespace with 1 container def on HPSS VFS.
- For data, indexes and LOBs.
- Added 3 other DMS tablespaces (1 regular, 2 large)
- 1 for data (regular) – 1 container in HPSS VFS
- 1 for indexes (large) - 1 container in HPSS VFS
- 1 for LOBs (large) - 1 container in HPSS VFS.
- Created duplicates of supplied tables/data in each new tablespace.
- Able to query data that “lives” on HPSS VFS

- Template Documentation

## DB2 Using HPSS VFS con’t

**Configurations currently being tested**
- DB2 Database (single node) Containers constructed on VFS
- SMS & DMS (file) Tablespaces being tested
- Query workloads
- Ingest Workloads
- HPSS Behavior

- Template Documentation

## DB2 Using HPSS VFS con’t

**Next**
- Determine how different configuration types perform (insert/load & select)
- 1 large container per tablespace in HPSS VFS
- Multiple small containers per tablespace in HPSS VFS
- Varying VVBLOCKSIZE & Segment configurations
- Try building entire database in HPSS VFS
- Test environment where data is on tape
- Partitioned databases
- How do we scale this?

- Template Documentation

## DB2 Partitioned database using HPSS VFS

**Issues****	**
- Data partitioning
- use same partitioning info for “live” data and VFS data?
- MDC?
- Use single/multiple VFS nodes
- Use single/multiple container files per tablespace
- Use single/multiple HPSS Core Servers (Name spaces)
- Indexing
- Large Objects
- Ingest
- Backup/Recovery – How to do a complete database backup with tablespaces using HPSS
- Disaster Recovery

- Template Documentation

## Slide 12

- Template Documentation

## Other Ideas

**DB2 Content Manager using HPSS VFS as the “mount point” for the resource manager**
**TSM storage pools (local file system type) using HPSS VFS**
**Create Entire DB2 Database on VFS  **
**......****..**

- Template Documentation