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

Philip Nelson

I get -

db2inst1@dvorak /db2data $ db2 "create database DBTST001 automatic storage
yes on /db2data/db2db dbpath on /db2data/db2db"
SQL0805N Package "NULLID.SQLE2F0 J 0X4141414141654 557" 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

Subscribe Reply

3083

Serge Rielau

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.SQLE2F0 J 0X4141414141654 557" 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

Philip Nelson

Serge Rielau wrote:

Philip Nelson wrote:
>I get -

db2inst1@dvora k /db2data $ db2 "create database DBTST001 automatic
storage yes on /db2data/db2db dbpath on /db2data/db2db"
SQL0805N Package "NULLID.SQLE2F0 J 0X4141414141654 557" was not found.
SQLSTATE=510 02

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_DISTIN CT_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

Serge Rielau

Philip Nelson wrote:

Serge Rielau wrote:

>Philip Nelson wrote:
>>I get -

db2inst1@dvor ak /db2data $ db2 "create database DBTST001 automatic
storage yes on /db2data/db2db dbpath on /db2data/db2db"
SQL0805N Package "NULLID.SQLE2F0 J 0X4141414141654 557" was not found.
SQLSTATE=5100 2

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_DISTIN CT_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

Philip Nelson

Serge Rielau wrote:

Philip Nelson wrote:
>Serge Rielau wrote:

>>Philip Nelson wrote:
I get -

db2inst1@dvo rak /db2data $ db2 "create database DBTST001 automatic
storage yes on /db2data/db2db dbpath on /db2data/db2db"
SQL0805N Package "NULLID.SQLE2F0 J 0X4141414141654 557" was not found.
SQLSTATE=510 02

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_DISTIN CT_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_sys tem_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_DISTIN CT_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_DISTIN CT_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 0X4141414141654 5
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_DISTIN CT_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.SQLE2F 0
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

Philip Nelson

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

Similar topics

12436

can't create database

by: W.Davis | last post by:

Group, I'm using ver 5 with winXP. I can access the test database, but can't create a table. I can't create ANY database as I keep getting error 1044 (42000): Access denied for user: ' '@'localhost' to database 'mynewdatabase'. Can you help? TIA, Wade

MySQL Database

1977

Create database

by: Oscar A. Moreno | last post by:

This is a newbie question. I have installed MySQL 4.1.7-Standard in MacOS X (10.3.5). I have ONLY database test. According to the manual there should be TWO. test and mysql. I have re-run mysql_install_db several times with the same result. Can some mysql guru explain or point me to the right page to have this mysql database in my system? Thanks in advance. Oscar A. Moreno oscar.moreno@att.net

MySQL Database

8688

Can "CREATE DATABASE" or "CREATE TABLE" be wrapped in transactions?

by: Robin Tucker | last post by:

I have some code that dynamically creates a database (name is @FullName) and then creates a table within that database. Is it possible to wrap these things into a transaction such that if any one of the following fails, the database "creation" is rolledback. Otherwise, I would try deleting on error detection, but it could get messy. IF @Error = 0 BEGIN SET @ExecString = 'CREATE DATABASE ' + @FullName EXEC sp_executesql @ExecString

Microsoft SQL Server

3278

pg_autovacuum causes 'create database' to fail when the first is accessing 'template1'

by: Frank van Vugt | last post by:

Hi, I noticed that when using the single commandline: drop database <name>; create database <name>; this sometimes fails due to a pg_autovacuum process running on the background. When this happens, the error returned is:

PostgreSQL Database

3762

DB2 AIX Create Database fails with Memory Allocation Error

by: Puppy | last post by:

I am trying to create a new database using DB2 UDB 8.1 on AIX. When I attempt to use the control center GUI, the error being returned is: SQL1224N, SQLSTATE 55032. When I attempt to use the command line, I get: SQL00083. What I can't believe is that there would be a memory allocation error b/c the 32 bit version of DB2 is running and there's nothing else active on the server. Any ideas?

DB2 Database

2806

how to create database in mssql server

by: Nanda | last post by:

hi, how to create database in mssql server using c#. We can create msacess database using adox, similiarly how to create sql server database using c#. Regards, Nanda.

C# / C Sharp

3777

Help me to Create Database

by: Anantha | last post by:

Dear All, One day our Windows 2000 Server OS crashed, so our NT admin has re-installed the OS on C: drive. Fortunately we kept our database file and installation in F: drive. When we re-installed DB2 on the same location we are able to catalog and recover the database with old data files. Now the problem is when i tried to create a database its throwing errors "SQL1092N NCADMIN" does not have the authority to perform the requested". So...

DB2 Database

2754

Create Database privilege at an instance for user/group

by: jatinder.saundh | last post by:

Hi, How do I give create database privielege to a specific user/group at a particular db2 instance ? I read about various authorities like SYSCTRL etc. but I am interested in giving only Create database privilege. I also came across GRANT <system privilege statement and it seems I can execute following statement to achieve what I want, GRANT CREATEDBA to <authorization-name>

DB2 Database

8972

DB2 Express - cannot create database!

by: Sue | last post by:

I just installed the free DB2 Express. I am going through the wizard and I am unable to create a database. I keep getting the error "create database path does not exist". The log file says "An attempt is made to create a database on a path without first enabling this feature using db2_create_db_on_path registry variable. Please enable this first and try again. When I tried to set this to yes, I get another error message "no database...

DB2 Database

10569

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10325

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10315

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10075

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6847

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5519

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5651

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3815

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2990

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General