By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,880 Members | 2,279 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,880 IT Pros & Developers. It's quick & easy.

Express-C (Linux 32-bit) : CREATE DATABASE fails

P: n/a
I get -

db2inst1@dvorak /db2data $ db2 "create database DBTST001 automatic storage
yes on /db2data/db2db dbpath on /db2data/db2db"
SQL0805N Package "NULLID.SQLE2F0J 0X4141414141654557" was not found.
SQLSTATE=51002

At least one other person on the IRC forum reports the same thing, so it
isn't my install.

Missing package in the release build ?

Phil
Jul 30 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
Philip Nelson wrote:
I get -

db2inst1@dvorak /db2data $ db2 "create database DBTST001 automatic storage
yes on /db2data/db2db dbpath on /db2data/db2db"
SQL0805N Package "NULLID.SQLE2F0J 0X4141414141654557" was not found.
SQLSTATE=51002

At least one other person on the IRC forum reports the same thing, so it
isn't my install.

Missing package in the release build ?
Philip,
Best post this in the DB2 Express C forum. Rahul or one of the other
moderators will track it down.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Jul 30 '06 #2

P: n/a
Serge Rielau wrote:
Philip Nelson wrote:
>I get -

db2inst1@dvorak /db2data $ db2 "create database DBTST001 automatic
storage yes on /db2data/db2db dbpath on /db2data/db2db"
SQL0805N Package "NULLID.SQLE2F0J 0X4141414141654557" was not found.
SQLSTATE=51002

At least one other person on the IRC forum reports the same thing, so it
isn't my install.

Missing package in the release build ?
Philip,
Best post this in the DB2 Express C forum. Rahul or one of the other
moderators will track it down.

Cheers
Serge
Serge,

Have done so. I've looked into it a bit more, and this is from db2spcat.

In my db2diag.log I have -

2006-07-30-20.08.10.297499+060 I28270G802 LEVEL: Severe
PID : 3184 TID : 2988738224 PROC : db2agent (DBTST001)
INSTANCE: db2inst1 NODE : 000 DB : DBTST001
APPHDL : 0-64 APPID: *LOCAL.db2inst1.060730190808
AUTHID : DB2INST1
MESSAGE : DB2SPCAT_DISTINCT_TYPES: statement
DATA #1 : Hexdump, 93 bytes
0xB6F4E5E0 : 6372 6561 7465 2064 6973 7469 6E63 7420 create distinct
0xB6F4E5F0 : 7479 7065 2053 5953 5052 4F43 2E44 4232 type SYSPROC.DB2
0xB6F4E600 : 5345 4355 5249 5459 4C41 4245 4C20 2061 SECURITYLABEL a
0xB6F4E610 : 7320 5641 5243 4841 5220 2831 3238 2920 s VARCHAR (128)
0xB6F4E620 : 464F 5220 4249 5420 4441 5441 2057 4954 FOR BIT DATA WIT
0xB6F4E630 : 4820 434F 4D50 4152 4953 4F4E 53 H COMPARISONS

Why are they creating this at all, when AFAIK Express-C doesn't have LBAC ?

Maybe they decided to remove it at the last minute ?

Phil
Jul 30 '06 #3

P: n/a
Philip Nelson wrote:
Serge Rielau wrote:
>Philip Nelson wrote:
>>I get -

db2inst1@dvorak /db2data $ db2 "create database DBTST001 automatic
storage yes on /db2data/db2db dbpath on /db2data/db2db"
SQL0805N Package "NULLID.SQLE2F0J 0X4141414141654557" was not found.
SQLSTATE=51002

At least one other person on the IRC forum reports the same thing, so it
isn't my install.

Missing package in the release build ?
Philip,
Best post this in the DB2 Express C forum. Rahul or one of the other
moderators will track it down.

Cheers
Serge

Serge,

Have done so. I've looked into it a bit more, and this is from db2spcat.

In my db2diag.log I have -

2006-07-30-20.08.10.297499+060 I28270G802 LEVEL: Severe
PID : 3184 TID : 2988738224 PROC : db2agent (DBTST001)
INSTANCE: db2inst1 NODE : 000 DB : DBTST001
APPHDL : 0-64 APPID: *LOCAL.db2inst1.060730190808
AUTHID : DB2INST1
MESSAGE : DB2SPCAT_DISTINCT_TYPES: statement
DATA #1 : Hexdump, 93 bytes
0xB6F4E5E0 : 6372 6561 7465 2064 6973 7469 6E63 7420 create distinct
0xB6F4E5F0 : 7479 7065 2053 5953 5052 4F43 2E44 4232 type SYSPROC.DB2
0xB6F4E600 : 5345 4355 5249 5459 4C41 4245 4C20 2061 SECURITYLABEL a
0xB6F4E610 : 7320 5641 5243 4841 5220 2831 3238 2920 s VARCHAR (128)
0xB6F4E620 : 464F 5220 4249 5420 4441 5441 2057 4954 FOR BIT DATA WIT
0xB6F4E630 : 4820 434F 4D50 4152 4953 4F4E 53 H COMPARISONS

Why are they creating this at all, when AFAIK Express-C doesn't have LBAC ?

Maybe they decided to remove it at the last minute ?
There should be information about the error itself either above to below
this entry.
It's hard to believe that any such error would appear only on Linux32.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Jul 30 '06 #4

P: n/a
Serge Rielau wrote:
Philip Nelson wrote:
>Serge Rielau wrote:
>>Philip Nelson wrote:
I get -

db2inst1@dvorak /db2data $ db2 "create database DBTST001 automatic
storage yes on /db2data/db2db dbpath on /db2data/db2db"
SQL0805N Package "NULLID.SQLE2F0J 0X4141414141654557" was not found.
SQLSTATE=51002

At least one other person on the IRC forum reports the same thing, so
it isn't my install.

Missing package in the release build ?
Philip,
Best post this in the DB2 Express C forum. Rahul or one of the other
moderators will track it down.

Cheers
Serge

Serge,

Have done so. I've looked into it a bit more, and this is from
db2spcat.

In my db2diag.log I have -

2006-07-30-20.08.10.297499+060 I28270G802 LEVEL: Severe
PID : 3184 TID : 2988738224 PROC : db2agent
(DBTST001)
INSTANCE: db2inst1 NODE : 000 DB : DBTST001
APPHDL : 0-64 APPID: *LOCAL.db2inst1.060730190808
AUTHID : DB2INST1
MESSAGE : DB2SPCAT_DISTINCT_TYPES: statement
DATA #1 : Hexdump, 93 bytes
0xB6F4E5E0 : 6372 6561 7465 2064 6973 7469 6E63 7420 create distinct
0xB6F4E5F0 : 7479 7065 2053 5953 5052 4F43 2E44 4232 type SYSPROC.DB2
0xB6F4E600 : 5345 4355 5249 5459 4C41 4245 4C20 2061 SECURITYLABEL a
0xB6F4E610 : 7320 5641 5243 4841 5220 2831 3238 2920 s VARCHAR (128)
0xB6F4E620 : 464F 5220 4249 5420 4441 5441 2057 4954 FOR BIT DATA WIT
0xB6F4E630 : 4820 434F 4D50 4152 4953 4F4E 53 H COMPARISONS

Why are they creating this at all, when AFAIK Express-C doesn't have LBAC
?

Maybe they decided to remove it at the last minute ?
There should be information about the error itself either above to below
this entry.
It's hard to believe that any such error would appear only on Linux32.

Cheers
Serge
I've only tried on Linux32. I have downloaded the Win32 version too, but
have yet to try installing it.

Here's the full dump -

2006-07-30-20.07.08.959804+060 E25854G465 LEVEL: Warning (OS)
PID : 3592 TID : 3045897904 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloqualifydir, probe:30
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.
CALLED : OS, -, unspecified_system_function OSERR: ENOENT (2)
DATA #1 : File name, 11 bytes
/db2data/db

2006-07-30-20.07.09.031662+060 I26320G342 LEVEL: Warning
PID : 3592 TID : 3045897904 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqlecrea, probe:25
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
DIA8411C A file "" could not be found.

2006-07-30-20.08.10.295729+060 I26663G385 LEVEL: Severe
PID : 3184 TID : 2988738224 PROC : db2agent (DBTST001)
INSTANCE: db2inst1 NODE : 000 DB : DBTST001
APPHDL : 0-64 APPID: *LOCAL.db2inst1.060730190808
AUTHID : DB2INST1
FUNCTION: DB2 UDB, base sys utilities, system_types, probe:10
RETCODE : ZRC=0xFFFFFCDB=-805

2006-07-30-20.08.10.296554+060 I27049G648 LEVEL: Severe
PID : 3184 TID : 2988738224 PROC : db2agent (DBTST001)
INSTANCE: db2inst1 NODE : 000 DB : DBTST001
APPHDL : 0-64 APPID: *LOCAL.db2inst1.060730190808
AUTHID : DB2INST1
MESSAGE : DB2SPCAT_DISTINCT_TYPES: sqlcode
DATA #1 : Hexdump, 54 bytes
0xBFE92374 : 4372 6561 7465 2053 5953 5052 4F43 2044 Create SYSPROC D
0xBFE92384 : 4953 5449 4E43 5420 5459 5045 2044 4232 ISTINCT TYPE DB2
0xBFE92394 : 5345 4355 5249 5459 4C41 4245 4C2C 2072 SECURITYLABEL, r
0xBFE923A4 : 633D 2D38 3035 c=-805

2006-07-30-20.08.10.297057+060 I27698G571 LEVEL: Severe
PID : 3184 TID : 2988738224 PROC : db2agent (DBTST001)
INSTANCE: db2inst1 NODE : 000 DB : DBTST001
APPHDL : 0-64 APPID: *LOCAL.db2inst1.060730190808
AUTHID : DB2INST1
MESSAGE : DB2SPCAT_DISTINCT_TYPES: sqlerrmc
DATA #1 : Hexdump, 34 bytes
0xBFE92786 : 4E55 4C4C 4944 2E53 514C 4532 4630 4A20 NULLID.SQLE2F0J
0xBFE92796 : 3058 3431 3431 3431 3431 3431 3635 3435 0X41414141416545
0xBFE927A6 : 3537 57

2006-07-30-20.08.10.297499+060 I28270G802 LEVEL: Severe
PID : 3184 TID : 2988738224 PROC : db2agent (DBTST001)
INSTANCE: db2inst1 NODE : 000 DB : DBTST001
APPHDL : 0-64 APPID: *LOCAL.db2inst1.060730190808
AUTHID : DB2INST1
MESSAGE : DB2SPCAT_DISTINCT_TYPES: statement
DATA #1 : Hexdump, 93 bytes
0xB6F4E5E0 : 6372 6561 7465 2064 6973 7469 6E63 7420 create distinct
0xB6F4E5F0 : 7479 7065 2053 5953 5052 4F43 2E44 4232 type SYSPROC.DB2
0xB6F4E600 : 5345 4355 5249 5459 4C41 4245 4C20 2061 SECURITYLABEL a
0xB6F4E610 : 7320 5641 5243 4841 5220 2831 3238 2920 s VARCHAR (128)
0xB6F4E620 : 464F 5220 4249 5420 4441 5441 2057 4954 FOR BIT DATA WIT
0xB6F4E630 : 4820 434F 4D50 4152 4953 4F4E 53 H COMPARISONS

2006-07-30-20.08.10.298563+060 I29073G336 LEVEL: Severe
PID : 3592 TID : 3045897904 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.060730190808
MESSAGE : SQLESCDB: sqlcode
DATA #1 : Hexdump, 14 bytes
0xBFCEC748 : 7371 6C63 6F64 6520 3D20 2D38 3035 sqlcode = -805

2006-07-30-20.08.10.299039+060 I29410G914 LEVEL: Severe
PID : 3592 TID : 3045897904 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.060730190808
MESSAGE : SQLESCDB : sqlca
DATA #1 : Hexdump, 136 bytes
0xB7572A20 : 5351 4C43 4120 2020 8800 0000 DBFC FFFF SQLCA ........
0xB7572A30 : 2200 4E55 4C4C 4944 2E53 514C 4532 4630 ".NULLID.SQLE2F0
0xB7572A40 : 4A20 3058 3431 3431 3431 3431 3431 3635 J 0X414141414165
0xB7572A50 : 3435 3537 2020 2020 2020 2020 2020 2020 4557
0xB7572A60 : 2020 2020 2020 2020 2020 2020 2020 2020
0xB7572A70 : 2020 2020 2020 2020 5351 4C52 4131 3346 SQLRA13F
0xB7572A80 : 6D00 1A80 0000 0000 0000 0000 0000 0000 m...............
0xB7572A90 : ECFF FFFF 0000 0000 2020 2020 2020 2020 ........
0xB7572AA0 : 2020 2035 3130 3032 51002

2006-07-30-20.08.10.299542+060 I30325G404 LEVEL: Error
PID : 3592 TID : 3045897904 PROC : db2bp
INSTANCE: db2inst1 NODE : 000
APPID : *LOCAL.db2inst1.060730190808
FUNCTION: DB2 UDB, base sys utilities, sqlecrea, probe:75
MESSAGE : Error creating catalog views, sqlcode =
DATA #1 : Hexdump, 4 bytes
0x081C2700 : DBFC FFFF ....

Jul 30 '06 #5

P: n/a
According to the Express-C forum they have found and fixed this problem and
are uploading a new image as I type this.

Phil
Aug 1 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.