IBM DB2 9, DB2 V8 manual XIX Sample SMS Storage Group Assignments

Models: DB2 V8 DB2 9

1 51
Download 51 pages 32.56 Kb
Page 50
Image 50

XIX Sample SMS Storage Group Assignments

1.Here is a sample assignment methodology for setting up SMS Storage Groups. One recommendation is to name the storage groups starting with the 3 character SAP <SID> followed by the type of dataset.

STORAGE GROUP Name

Dataset Type

Sample Name (<SID>=DR1)

LOG

DB2 Active Log Datasets/BSDS/

 

SGDR1LOG

 

ICF Catalog for Active Logs, BSDS,

 

 

Archive Logs

 

 

ARCH

DB2 Archive Log Datasets

 

SGDR1ARC

CAT

DB2 Catalog/Directory/DSNDB07/

SGDR1CAT

 

DB2 System Libraries,

 

 

 

ICF Catalog for Catalog, Directory,

 

 

System Libraries

 

 

DATA

SAP Tablespaces/Indexspaces,

 

SGDR1SAP

 

ICF Catalog for SAP Tablespaces/

 

 

Indexspaces

 

 

COPY

DB2 Image Copies, ICF Catalog

 

SGDR1IC

 

For Image Copies

 

 

(WORK

DSNDB07

 

SGDR1WK )

Copyright 2006 IBM Solutions Technical Sales (STS)

12/18/2007Page 50 of 51

12/18/2007

 

Page 50
Image 50
IBM DB2 9, DB2 V8 manual XIX Sample SMS Storage Group Assignments