Results 1 to 11 of 11
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: db2 package marked inoperative

    Dear all,

    I am using DB2 10.1 on RHEL 6. I restored a db2 9.7 v over it now i see that db has been upgraded but so many packages of schema NULLID are seen INOPERATIVE like AOTMH00, SQLC2E06, SQLC2H21... etc.

    statement: list tables for schema myschema //through API TOAD for DB2 4.7

    a brief error is as
    Error 9/20/2013 12:24:09 PM 0:00:00.000 DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0572N Package "NULLID.SQLC2H21" is inoperative. SQLSTATE=51028 51 0

    I tried to rebind/bind but same error as above is coming while rebind itself.
    Please suggest

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi,

    These are packages for the db2 9.7 utilities.
    DB2 v9.7 Bind File and Package Name List.
    You need them only if you want to run these utilities against your 10.1 database from 9.7 client with corresponding fixpack.
    In this case you should rebind these packages from this particular 9.7 client using:
    Code:
    db2 bind @db2ubind.lst blocking all grant public
    Regards,
    Mark.

  3. #3
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    db2bind

    Thanks mark..

    db2 bind @db2ubind.lst blocking all grant public

    Please suggest what "blocking all grant public" what it means. Can i run this on live environment without risk.

    thanks in advance.

  4. #4
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    BIND command.

    You can run this without risk.
    This is one of the standard steps after installing a fix pack, for example.
    Binding bind files after installing fix packs
    Regards,
    Mark.

  5. #5
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    db2ubind.lst

    Hello mark/ all,


    Please guide while running
    db2 bind @db2ubind.lst blocking all grant public

    i observed that one bnd file db2clpcs.bnd is missing from db2ubind.lst file.
    so the related packages remain invalid.

    Please suggest shall i edit db2ubind.lst or there is some other way around.

    thanks

  6. #6
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Quote Originally Posted by ssumit View Post
    i observed that one bnd file db2clpcs.bnd is missing from db2ubind.lst file.
    so the related packages remain invalid.
    Is this some run-time client where this bind file is missing from db2ubind.lst?
    What are the platform, db2 version, edition, fixpack?
    Regards,
    Mark.

  7. #7
    Join Date
    Sep 2013
    Location
    India
    Posts
    246
    Quote Originally Posted by mark.b View Post
    Is this some run-time client where this bind file is missing from db2ubind.lst?
    What are the platform, db2 version, edition, fixpack?


    i am running bind command on server

    cd /home/db2inst1/sqllib/bnd

    there is file db2ubind.lst which contain so many packages name but not that i needed


    environment
    RHEL 5, DB2 10.1.0.0 FP 0

    client is toad 4.2 for db2 9.7 on client machine.



    Please suggest
    ______
    Regards
    ssumit

  8. #8
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    You have invalid packages which belong to 9.7 version clients, not for 10.1.
    So you are not able to bind those packages from the server.
    AFAIK toad uses db2 Runtime client which doesn't use these packages at all.

    Once again, if you do have namely DB2 Clients (not DB2 Runtime clients), then you can bind db2ubind.lst namely from one of these clients (and not from the server).
    Regards,
    Mark.

  9. #9
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    package marked inoerative

    Hi mark,



    I am using Toad for Db2 4.7 (db2 9.7 client) My db is Db2 10.1.0.0 on RHEL 5

    when firing statement

    list tables for schema myschema

    below error is thrown. Please suggest what to do in this case as u told it is a runtime client


    Category Timestamp Duration Message Line Position
    Error 9/21/2013 2:26:35 PM 0:00:00.000 DB21034E The command was processed as an SQL statement because it was not a
    valid Command Line Processor command. During SQL processing it returned:
    SQL0572N Package "NULLID.SQLC2H21" is inoperative. SQLSTATE=51028 8 0


    regards
    sumit


  10. #10
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    If this package is still inoperative after running
    db2 bind @db2ubind.lst
    from this client, then you can try to rebind this package explicitly.
    Just run on the server:
    Code:
    db2 "rebind package NULLID.SQLC2H21"
    Alternatively you can try to rebind this package from the client:

    Code:
    java com.ibm.db2.jcc.DB2Binder -url jdbc:db2://hostname:port/dbname -user name -password pwd -generic -collection NULLID -package SQLC2H22
    Regards,
    Mark.

  11. #11
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    shared memory

    Thanks mark...

    It worked.. My problem solved

    cheers

Posting Permissions

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