Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    2

    Unanswered: JDBC failure to DB2 on MVS

    com.ibm.db2.jcc.DB2Driver
    getConnection to database on MVS(?) fine
    executeQuery error:

    DB2 SQL error: SQLCODE: -904, SQLSTATE: 57011, SQLERRMC:
    00C200E0;00000700;BP10

    Thanks for any help.

    Jason

  2. #2
    Join Date
    May 2003
    Posts
    113
    Quote Originally Posted by jdb2
    com.ibm.db2.jcc.DB2Driver
    getConnection to database on MVS(?) fine
    executeQuery error:

    DB2 SQL error: SQLCODE: -904, SQLSTATE: 57011, SQLERRMC:
    00C200E0;00000700;BP10

    Thanks for any help.

    Jason
    the following from the 'code' book for db2/zos. The softcopy of such book is available on line. You better have such document handy for your work.

    00C200E0
    Explanation: A table space or index space cannot be accessed because DB2 is unable to create the referenced buffer pool. The referenced buffer pool size was zero, which indicates to DB2 that this buffer pool should not be activated. DB2 message DSNB602I was issued to inform the operator of the error. This reason code and the table space or index space name are recorded in the cursor table (CT) and made available to the user in the SQLCA.

    This abend reason code is issued by the following CSECTs: DSNB1OPP DSNB1OPS

    System action: An SQLCODE -904 (resource not available) is returned to the user. The SVC dump and the SYS1.LOGREC recording are not requested.

    System programmer response: Analyze the virtual storage content of the ssnmDBM1 address space to determine further action. If appropriate, use the ALTER TABLESPACE or ALTER INDEX statement to modify the affected table space or index to indicate a usable buffer pool. To determine a usable buffer pool, use the DISPLAY BUFFERPOOL command. If necessary, use the ALTER BUFFERPOOL command to activate the failing buffer pool by setting its VPSIZE to a nonzero value.

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Another good resources is this: http://www-03.ibm.com/servers/eserve...bkserv/lookat/

    Just key in the reason code/sqlcode/... and click on "GO".
    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
  •