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 > Exporting data in parallel using db2batch

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-25-05, 11:57
udbraja udbraja is offline
Registered User
 
Join Date: Sep 2004
Posts: 111
Arrow Exporting data in parallel using db2batch

Team,

AIX-5.2 Fp7 64bit 1physical 4logical partitions

db2batch -p s -d sample -f emp.sql -r /home/emp.del -q del

emp.sql file contains "select * from employee;"

Result -> getting in all nodes
=====
rah: Using single-depth method since tree method cannot echo command.
Execution may be slower.

bssp114i:
bssp114i: SQL0805N Package "NULLID.TOOL2E00 0X4141414141614853" was not found.
bssp114i: SQLSTATE=51002
bssp114i:
bssp114i:
bssp114i: An error condition occurred...Exiting
bssp114i:
bssp114i: batchslv -d sample ... completed rc=255

bssp114i:
bssp114i: SQL0805N Package "NULLID.TOOL2E00 0X4141414141614853" was not found.
bssp114i: SQLSTATE=51002
bssp114i:
bssp114i:
bssp114i: An error condition occurred...Exiting
bssp114i:
bssp114i: batchslv -d sample ... completed rc=255

Help please...

Thanks,
Rj
Reply With Quote
  #2 (permalink)  
Old 10-25-05, 12:15
J Petruk J Petruk is offline
Registered User
 
Join Date: Mar 2004
Location: Toronto, ON, Canada
Posts: 513
Try bind sqllib/bnd/batchslv.bnd, that seems to be the bind file with that package.

I don't see it in any of the .lst files, though, not sure why that is? Might as well bind db2ubind.lst again just to be sure.

jono
__________________
--
Jonathan Petruk
DB2 Database Consultant
Reply With Quote
  #3 (permalink)  
Old 10-25-05, 14:22
udbraja udbraja is offline
Registered User
 
Join Date: Sep 2004
Posts: 111
Arrow

Great Jonathan,

Just batchslv.bnd worked.

Thank you so much.

-Rj
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