IBM DB2 V8, DB2 9 manual +System related storage groups

Models: DB2 V8 DB2 9

1 51
Download 51 pages 32.56 Kb
Page 51
Image 51

ICF Catalog Names:

CATALOG.SAPDB2.DR1LOG

CATALOG.SAPDB2.DR1USR

CATALOG.SAPDB2.DR1DB2

CATALOG.SAPDB2.DR1IC

Catalog Structure:

Catalog

Alias

ACS Dataset Name

DR1USR

DR1U

DR1U.*

DR1IC

DR1IC

DR1IC.**

DR1DB2

DR1

DR1.SRCLIB DR1.DBRMLIB DR1.RUNLIB.LOAD

 

 

DR1.DSNDB*.DSN*.**

 

DR11

DR11.DSN*

DR1LOG

DR11.LOGCOPY1

DR11.LOG*.**

 

DR11.LOGCOPY2

DR11.BSDS*

 

DR11.BSDS01

DR11.ARCHLOG*

 

DR11.BSDS02

 

 

DR11.ARCHLOG1

 

 

DR11.ARCHLOG2

 

+System related storage groups:

SYS

System Datasets

PAGE

Page Datasets

SORT

Sort Datasets

SOFTW

Software Library Datasets

HFS

USS HFS Datasets

2.For implementation of the new DB2 V8 and DB2 9 utilities BACKUP SYSTEM and RESTORE SYSTEM, DB2 requires two SMS Copy Pools: DSN$location-name$DB for data (DB2 Catalog, DB2 Directory, SAP data) and DSN$location-name$LG for log data (DB2 Logs, BSDS, and DB2 Load Libraries). The appropriate SMS Storage Groups need to be assigned to the correct Copy Pool. Each pool requires a separate ICF Catalog.

Copyright 2006 IBM Solutions Technical Sales (STS)

12/18/2007Page 51 of 51

12/18/2007

 

Page 51
Image 51
IBM DB2 V8, DB2 9 manual +System related storage groups