hi,guys
i am new to db2, today when i created db, the problem came out.below is the code:
CREATE DATABASE testzy AUTOMATIC STORAGE NO ON 'C:\' USING CODESET UTF-8 TERRITORY US
COLLATE USING SYSTEM PAGESIZE 4096 CATALOG TABLESPACE MANAGED BY DATABASE USING ( FILE
'C:\PROGRA~1\IB M\SQLLIB\syscat able1' 5120 ) EXTENTSIZE 16 PREFETCHSIZE 16 OVERHEAD 10.50
TRANSFERRATE 0.14 USER TABLESPACE MANAGED BY DATABASE USING ( FILE 'C:\PROGRA~1
\IBM\SQLLIB\con t1' 5120, FILE 'C:\PROGRA~1\IB M\SQLLIB\TOOLS\ cont2' 5120 ) EXTENTSIZE 16
PREFETCHSIZE 16 OVERHEAD 10.50 TRANSFERRATE 0.14 TEMPORARY TABLESPACE MANAGED BY DATABASE
USING ( FILE 'C:\PROGRA~1\IB M\SQLLIB\tempta b1' 5120 ) EXTENTSIZE 16 PREFETCHSIZE 16 OVERHEAD
10.50 TRANSFERRATE 0.14;
SQL1043C Database Services could not initialize the system
catalogs. Error "-289" was returned.
Explanation:
The CREATE DATABASE command failed while initializing the system
catalogs.
User Response:
Record the message number (SQLCODE) and error in this message.
If trace was active, invoke the Independent Trace Facility at
the operating system command prompt. Then contact your technical
service representative with the following information:
o Environment: Application
o Required information:
- Problem description
- SQLCODE or message number and error identifier
- SQLCA contents if possible
- Trace file if possible.
i can't figure out what the problem is. anybody help, thanx~
i am new to db2, today when i created db, the problem came out.below is the code:
CREATE DATABASE testzy AUTOMATIC STORAGE NO ON 'C:\' USING CODESET UTF-8 TERRITORY US
COLLATE USING SYSTEM PAGESIZE 4096 CATALOG TABLESPACE MANAGED BY DATABASE USING ( FILE
'C:\PROGRA~1\IB M\SQLLIB\syscat able1' 5120 ) EXTENTSIZE 16 PREFETCHSIZE 16 OVERHEAD 10.50
TRANSFERRATE 0.14 USER TABLESPACE MANAGED BY DATABASE USING ( FILE 'C:\PROGRA~1
\IBM\SQLLIB\con t1' 5120, FILE 'C:\PROGRA~1\IB M\SQLLIB\TOOLS\ cont2' 5120 ) EXTENTSIZE 16
PREFETCHSIZE 16 OVERHEAD 10.50 TRANSFERRATE 0.14 TEMPORARY TABLESPACE MANAGED BY DATABASE
USING ( FILE 'C:\PROGRA~1\IB M\SQLLIB\tempta b1' 5120 ) EXTENTSIZE 16 PREFETCHSIZE 16 OVERHEAD
10.50 TRANSFERRATE 0.14;
SQL1043C Database Services could not initialize the system
catalogs. Error "-289" was returned.
Explanation:
The CREATE DATABASE command failed while initializing the system
catalogs.
User Response:
Record the message number (SQLCODE) and error in this message.
If trace was active, invoke the Independent Trace Facility at
the operating system command prompt. Then contact your technical
service representative with the following information:
o Environment: Application
o Required information:
- Problem description
- SQLCODE or message number and error identifier
- SQLCA contents if possible
- Trace file if possible.
i can't figure out what the problem is. anybody help, thanx~