Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    111

    Arrow Unanswered: 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

  2. #2
    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

  3. #3
    Join Date
    Sep 2004
    Posts
    111

    Arrow

    Great Jonathan,

    Just batchslv.bnd worked.

    Thank you so much.

    -Rj

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •