Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2011
    Posts
    5

    Unanswered: Db2 "sqlcode: -805, sqlstate: 51002, sqlerrmc: Nullid"

    We are running the following:

    AIX 5.3
    WAS 6.0, WAS ND 6.0.2.17, WCC 6.5
    DB2 v8.1.1.160 (fix pack 18)

    We get the following error:
    ############
    Error code:
    200000100

    Error Message:
    Reading an extension Person failed

    Throwable Message:
    java.lang.Exception: Exception while retrieving Alert Objects com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLN21E 0X5359534C564C3031

    com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: NULLID.SYSLN21E 0X5359534C564C3031

    We have:
    1. reviewed all application code and confirmed all open statements have a corresponding close statement
    2. our configuration for number of pkgs is at the maximum
    3. been advised this is fixed in v9.2 (upgrading is not an option at this point in time)

    Any ideas?

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    been advised this is fixed in v9.2 (????
    this is not a problem : please read the doc and find the sql code .....
    -805 just means : package missing
    have a look at doc and execute the bind for needed db2 packages
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows
    this is common for all versions
    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

  3. #3
    Join Date
    Aug 2011
    Posts
    5
    Been advised its fixed in 9.2, should have been 9.1

    known defect IZ44579

    https://www-304.ibm.com/support/docv...id=swg1IZ44579

    Error description
    When a program tries to open a lot of statement handles (up to the limit which is indicated by an SQL0805), and then closes some handles and again opens a new statement handle, then a SQL0805 error is received, even though this should not happen (because some handles were closed in between, at least same number of handles should be allowed to be opened as they were closed earlier)

    This behaviour is observed in universal (JCC T2 and T4) drivers
    while legacy drivers work as expected i.e. the application can
    create again as many statements as the cli-packages allow.

    This problem is observed on all versions i.e. DB2 V8.1, V8.2,
    V9.1, V9.5 using Universal Driver (JCC).

    NOTE: I am not a DBA, I am primarily middleware support, can you provide more info about this 'bind' reference you have made.

  4. #4
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    for users to be able to work with db2 some binds are needed - loading packages in db
    typical : db2ubind.lst db2cli.lst db2schema.bnd
    the lst files are just lists keeping bind files names
    so looking at the doc : you will see
    cd sqllib/bnd
    connect to db
    db2 bind db2schema.bnd blocking all grant public sqlerror continue or
    db2 bind @db2cli.lst ......... @ needed if list
    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

  5. #5
    Join Date
    Aug 2011
    Posts
    5
    DBAs have advised they have been through this steps already and verified.

    This has made no difference to the issue.

  6. #6
    Join Date
    Aug 2011
    Posts
    5
    Some more information provided by my DBAs,

    We have ran this command 'db2 bind @db2cli.lst blocking all sqlerror continue grant public CLIPKG 30' but we still ran out of packages
    The reason appears to be caused by the Universal driver not closing statement handles.

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

  8. #8
    Join Date
    Aug 2011
    Posts
    5
    As previously advised, we have verified the code is closing statements and connections.

    We have also found technotes indicating this is a known bug with DB2 version 8. As we are not in a position to upgrade to v9.2 (where the fix is), I would like to find out if anyone knows of any UDB driver fixes available for v8 (AIX).

  9. #9
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Either your application is not closing transactions properly or you don't commit often enough. I don't care how many code reviews you say you have done.

    Rebinding to allow more packages is like giving more drugs to a drug addict. It only makes things worse.
    Last edited by Marcus_A; 08-18-11 at 10:21.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  10. #10
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    I agree with Marcus. Your application does not properly close all statements or it runs too much stuff in parallel. Maybe some threads run into a wait/deadlock situation while having statements opened?

    p.s: V8 is out of service for years now.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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