467,891 Members | 1,830 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,891 developers. It's quick & easy.

Temporary tablespace managed by database

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\IBM\SQLLIB\syscatable1' 5120 ) EXTENTSIZE 16 PREFETCHSIZE 16 OVERHEAD 10.50

TRANSFERRATE 0.14 USER TABLESPACE MANAGED BY DATABASE USING ( FILE 'C:\PROGRA~1

\IBM\SQLLIB\cont1' 5120, FILE 'C:\PROGRA~1\IBM\SQLLIB\TOOLS\cont2' 5120 ) EXTENTSIZE 16

PREFETCHSIZE 16 OVERHEAD 10.50 TRANSFERRATE 0.14 TEMPORARY TABLESPACE MANAGED BY DATABASE

USING ( FILE 'C:\PROGRA~1\IBM\SQLLIB\temptab1' 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~
Apr 13 '10 #1
  • viewed: 1417
Share:

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Ulrich Sprick | last post: by
5 posts views Thread by N | last post: by
2 posts views Thread by Andy S. | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.