| View previous topic :: View next topic |
| Author |
Message |
vani
Beginner
Joined: 28 May 2003
Posts: 51
Topics: 30
|
 Posted: Mon Oct 13, 2003 8:59 am Post subject: Db2 catalog tables |
 |
|
Hi,
There is problem of catalog tables
There is an absence of two catalog tables(and the tablespaces) in DSNDB06 database(obviously!!) of DB2 ver 6.1
SYSIBM.SYSSEQUENCES
SYSIBM.SYSSEQUENCESDEP
The VSAM datasets pertaining to these are defined.
I tried initializing these VSAM's by using the installation job, DSNTIJID which ran fine but still no TABLES or TABLESPACES were
defined.
Is there any way of creating these tablespaces and tables? I have got the DDL's for the same but it is throwing the error
"CREATE is not permitted on this Catalog object"
Is there any way out????? |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose
|
| Posted: Mon Oct 13, 2003 10:20 am Post subject: |
|
|
vani,
Are you migrating from DB2 version 5 to 6 or Are you installing a fresh copy of DB2?
I guess you need to run the job DSNTIJIC? This job contains a list of all the DB2 directory and catalog table spaces. When you run job DSNTIJIC, it invokes the DB2 image copy utility to copy these table spaces to tape. The copied table spaces allow you to recover the DB2 catalog and DB2 directory in case of a failure. Before running job DSNTIJTC (CATMAINT), remove all views on catalog tables SYSIBM.SYSCOLDIST and SYSIBM.SYSCOLDISTSTATS. Catalog migration will fail if any views are found. After you have successfully migrated your catalog to Version 6, you can redefine the views.
Hope this helps...
cheers
kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
