If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > issue with package "NULLIDR1"

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Mar 2012
Posts: 109
issue with package "NULLIDR1"

Hi,
I'm writing a CLI application using DB2 10.1 ESE on Windows 64 bit.

I want to use a different REOPT bind option, I don't want REOPT NONE but REOPT ONCE.

What I did is:
> db2 connect to mydb
> db2 bind ../bnd/db2clipk.bnd blocking all grant public collection NULLIDR1
(command was successful, 0 errors and 0 warnings)
>db2 terminate

Then I added
REOPT=3
in my db2cli.ini file and restarted the instance.

When I run my application I get:

Database Error: [IBM][CLI Driver][DB2/NT64] SQL0805N The package "NULLIDR1.SYSSH200 0X5359534C564C3031" was not found. SQLSTATE=51002

Could you please help me solve this issue?
Thanks
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 2,206
__________________
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
Join Date: Mar 2012
Posts: 109
Thanks przytula_guy,
I started from this doc and in fact I did the same things suggested there, but got the error anyway.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 2,206
after :
REOPT=3 in my db2cli.ini file and restarted the instance.
did you executed the bind again ? maybe the db2cli.lst file instead
__________________
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
Join Date: Mar 2012
Posts: 109
same error
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On