Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2011
    Posts
    21

    Unanswered: DB2 connection error

    Hi,

    My Jazz Server client failed to connect to the DB2 database. stacktrace is as below, any idea ?

    I renamed db2diag.log as it got too big, and restarted DB2. Then I ran into this problem. I can see a new db2diag.log file was created however my client application failed to connect to the DB.

    Much Thanks,
    Dixie

    2013-06-17-23.45.40.895000+600 I4627381F1071 LEVEL: Severe
    PID : 3176 TID : 1948 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: vhost0148
    EDUID : 1948 EDUNAME: db2pclnr (JTS97)
    FUNCTION: DB2 UDB, base sys utilities, sqle_panic, probe:10
    DATA #1 : <preformatted>
    sqle_panic: Panic/sleep = 0x0
    CALLSTCK:
    [0] 0x000007FEF96AE5A4 pdLogPrintf + 0x3C4
    [1] 0x000007FEF96AE214 pdLogPrintf + 0x34
    [2] 0x000007FEE6433D67 sqle_panic + 0x247
    [3] 0x000007FEE603FA61 sqlb_panic + 0x41
    [4] 0x000007FEE60C3FD2 sqlbpini + 0x783F2
    [5] 0x000007FEF967F1F9 sqloLioReadWriteNBlocks + 0x149
    [6] 0x000007FEF967F0D8 sqloLioReadWriteNBlocks + 0x28
    [7] 0x000007FEE60CD216 sqlbpini + 0x81636
    [8] 0x000007FEE60C8C74 sqlbpini + 0x7D094
    [9] 0x000007FEE60C8A48 sqlbpini + 0x7CE68
    [10] 0x000007FEE82ED744 sqlzGetZRCInfo + 0x584
    [11] 0x000007FEF9672EAA sqloSpawnEDU + 0xE7A
    [12] 0x000000007725F33D BaseThreadInitThunk + 0xD
    [13] 0x00000000774E2CA1 RtlUserThreadStart + 0x21

    2013-06-17-23.45.40.895000+600 I4628454F526 LEVEL: Error
    PID : 3176 TID : 1948 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: vhost0148
    EDUID : 1948 EDUNAME: db2pclnr (JTS97)
    FUNCTION: DB2 UDB, oper system services, sqloSetPGRPCrashInfo, probe:2068
    MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
    DIA8411C A file "" could not be found.
    DATA #1 : String, 44 bytes
    Error setting crash information in PGRP file

    2013-06-17-23.45.40.895000+600 I4628982F530 LEVEL: Error
    PID : 3176 TID : 1948 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: vhost0148
    EDUID : 1948 EDUNAME: db2pclnr (JTS97)
    FUNCTION: DB2 UDB, oper system services, sqloPGRPRegisterOneCrash, probe:2147
    MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
    DIA8411C A file "" could not be found.
    DATA #1 : String, 44 bytes
    Error setting crash information in PGRP file

    2013-06-17-23.45.40.895000+600 I4629514F1314 LEVEL: Event
    PID : 3176 TID : 1948 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: vhost0148
    EDUID : 1948 EDUNAME: db2pclnr (JTS97)
    FUNCTION: DB2 UDB, oper system services, sqloPGRPRegisterOneCrash, probe:2154
    MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
    DIA8411C A file "" could not be found.
    DATA #1 : String, 14 bytes
    lastCrashCount
    DATA #2 : unsigned integer, 8 bytes
    0
    DATA #3 : String, 10 bytes
    inRecovery
    DATA #4 : Boolean, 1 bytes
    false
    CALLSTCK:
    [0] 0x000007FEF969A6E3 pdLog + 0x393
    [1] 0x000007FEF95A3D3B sqloPGRPRegisterOneCrash + 0x20B
    [2] 0x000007FEE6433D80 sqle_panic + 0x260
    [3] 0x000007FEE603FA61 sqlb_panic + 0x41
    [4] 0x000007FEE60C3FD2 sqlbpini + 0x783F2
    [5] 0x000007FEF967F1F9 sqloLioReadWriteNBlocks + 0x149
    [6] 0x000007FEF967F0D8 sqloLioReadWriteNBlocks + 0x28
    [7] 0x000007FEE60CD216 sqlbpini + 0x81636
    [8] 0x000007FEE60C8C74 sqlbpini + 0x7D094
    [9] 0x000007FEE60C8A48 sqlbpini + 0x7CE68
    [10] 0x000007FEE82ED744 sqlzGetZRCInfo + 0x584
    [11] 0x000007FEF9672EAA sqloSpawnEDU + 0xE7A
    [12] 0x000000007725F33D BaseThreadInitThunk + 0xD
    [13] 0x00000000774E2CA1 RtlUserThreadStart + 0x21

    2013-06-17-23.45.40.895000+600 I4630830F431 LEVEL: Info
    PID : 3176 TID : 1948 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: vhost0148
    EDUID : 1948 EDUNAME: db2pclnr (JTS97)
    FUNCTION: DB2 UDB, base sys utilities, sqleCleanupResources, probe:4157
    DATA #1 : String, 24 bytes
    Process Termination Code
    DATA #2 : Hex integer, 4 bytes
    0x00000000

    2013-06-17-23.45.40.895000+600 I4631263F496 LEVEL: Warning
    PID : 3176 TID : 1948 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: vhost0148
    EDUID : 1948 EDUNAME: db2pclnr (JTS97)
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
    MESSAGE : Bringing down all db2fmp processes as part of db2stop
    DATA #1 : Hexdump, 4 bytes
    0x0000000008AFDC20 : 0000 0000 ....

    2013-06-17-23.45.40.895000+600 E4631761F436 LEVEL: Warning
    PID : 3176 TID : 1948 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: vhost0148
    EDUID : 1948 EDUNAME: db2pclnr (JTS97)
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
    DATA #1 : String, 36 bytes
    As part of db2stop terminating fmp:
    DATA #2 : Process ID, 4 bytes
    3348

    2013-06-17-23.45.40.895000+600 E4632199F436 LEVEL: Warning
    PID : 3176 TID : 1948 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    HOSTNAME: vhost0148
    EDUID : 1948 EDUNAME: db2pclnr (JTS97)
    FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:6
    DATA #1 : String, 36 bytes
    As part of db2stop terminating fmp:
    DATA #2 : Process ID, 4 bytes
    3236

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    There should be additional errors logged prior to the first one you posted:

    Please perform the following:

    db2cmd
    db2diag -A
    db2 connect to jts97


    Post the exact error message from the last command and attach new db2diag.log.


    What was done to this db just prior to the first failure? Any restore (db2/OS), config changes, hardware problem, etc... ?

  3. #3
    Join Date
    Oct 2011
    Posts
    21
    Hi db2girl,

    Thank you so very much for replying. The output :

    C:\Program Files\IBM\SQLLIB\BIN>db2diag -A
    db2diag: Moving "C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2diag.l og"
    to "C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2diag.log_2 013-06-18-06.3
    1.37"


    C:\Program Files\IBM\SQLLIB\BIN>db2 connect to jts97
    SQL1032N No start database manager command was issued. SQLSTATE=57019


    There was no db restore before I renamed db2diag.log to db2diag.20130617.log

    However there was a SQLCODE= -1036, SQLSTATE=58030 for starting one of my databases DW2012, the original db2diag.log was too big I cannot open it to read, hence I renamed it then ran into this -4499 -08001 problem.

    Thanks,
    Dixie
    Attached Files Attached Files
    Last edited by dixiefu; 06-17-13 at 17:49.

  4. #4
    Join Date
    Oct 2011
    Posts
    21
    Hi db2girl,

    I restart db2 and activate my databases in following sequence:

    1. db2stop
    2. db2start
    3. db2 list active databases (nothing was listed)
    4. db2 activate database JTS97
    5. db2 activate database QM
    6. db2 activate database CCM
    7. db2 list active databases ( it showed the above 3 databases)
    8. restart my application & run it
    9. ran into problem of connection reset

    db2diag.log is attached.

    Much Appreciated,
    Dixie
    Attached Files Attached Files

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Is your diaglevel set to 4? db2diag.log has way too many Info messages. If it's 4, please lower it to 3.


    It looks like there is some corruption:

    CCM - possibly index corruption
    Obj: {pool:3;obj:128;type:1} Parent={3;128}


    JTS97 - possibly LOB corruption
    Obj: {pool:3;obj:328;type:3} Parent={3;328}


    Please perform db2dart for both databases:
    db2dart <db name>


    If you have support, I suggest to open a pmr.
    Last edited by db2girl; 06-17-13 at 19:37.

  6. #6
    Join Date
    Oct 2011
    Posts
    21
    Hi,

    CCM is one of my db2 database in that DB2 instance.

    I was trying to do a backup of this database with following command, and got error of "SQL0901N The SQL statement or command failed because of a database system
    error. (Reason "1117".) SQLSTATE=58004".

    db2diag.log is attached.

    Please help.

    Much appreciated,
    Dixie

    commands:
    CONNECT TO CCM;
    QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
    CONNECT RESET;
    DEACTIVATE DATABASE CCM;
    BACKUP DATABASE CCM user xxxxxx using xxxxxx TO "F:\DB2 backups" EXCLUDE LOGS WITHOUT PROMPTING;
    Attached Files Attached Files

  7. #7
    Join Date
    Oct 2011
    Posts
    21
    Hi db2girl,

    Thank you so much for helping out.

    "db2dart JTS97" reported no error.

    However "db2dart CCM" returned "Error: Failed sqledosd API on open local database directory E:\TAFDev\DB2.
    SQL1031N The database directory cannot be found on the indicated file system."

    CCM's table spaces are located in E:\TAFDev Data\DB2, and it had been working fine for me for almost a year, why all of the sudden it looked E:\TAFDev\DB2 ? How can I instructed it to look at the right folder ? I am using window 2008 64 bit machine.


    Much Appreciated,
    Dixie


    -------------------------------------------------------------------------

    Table inspection end.

    Table inspection start: RESOURCE.INDEXER

    Table inspection end.

    Table inspection start: RESOURCE.XML_TEXT_SCHEMA
    Table inspection end.

    Table inspection start: RESOURCE.DEFAULT_TEXT_DESCRIPTION

    Table inspection start: RESOURCE.DEFAULT_TEXT_DESCRIPTION_FOR_TYPES
    Table inspection start: RESOURCE.FIELDS_TEXT_DESCRIPTION

    Table inspection start: RESOURCE.FIELDS_TEXT_DESCRIPTION_FIELDS


    Table inspection start: RESOURCE.FIELDS_TEXT_DESCRIPTION_FOR_TYPES


    Table inspection start: FRIENDS.FRIEND


    The requested DB2DART processing has completed successfully!
    All operation completed without error;
    no problems were detected in the database.
    ______________________________________

    Complete DB2DART report found in: JTS97.RPT

    _______ D A R T P R O C E S S I N G C O M P L E T E _______


    -------------------------------------------------------------------------


    Below is the output of "db2dart ccm",



    C:\Program Files\IBM\SQLLIB\BIN>db2dart ccm

    __________________________________________________ __________________

    _____ D B 2 D A R T _____

    Database Analysis Tool

    I B M

    DB2 NT


    The DB2DART Tool is a utility for the analysis of databases,
    tablespaces, and tables. DART's primary function is to
    examine databases for their architectural correctness, and to
    report any encountered errors.
    __________________________________________________ __________________


    Error: Failed sqledosd API on open local database directory E:\TAFDev\DB2.
    SQL1031N The database directory cannot be found on the indicated file system.

    Error: This phase encountered an error and did not complete.
    ______________________________________

    DB2DART Processing completed with error!

    WARNING:
    The inspection phase did not complete!

    ______________________________________

    Complete DB2DART report found in: CCM.RPT

    _______ D A R T P R O C E S S I N G C O M P L E T E _______


    C:\Program Files\IBM\SQLLIB\BIN>

  8. #8
    Join Date
    Oct 2011
    Posts
    21
    Hi db2girl,

    Sorry I don't have support. I am using the Express version.

    Thanks,
    Dixie

  9. #9
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I wouldn't know what happened to your database/tablespace path. Any hardware problem?

    DB2 is consistently reporting this error when accessing a page:
    MESSAGE : ZRC=0x8300045D=-2097150883


    I can't access DB2 on Windows and DB2 on other platforms doesn't seem to show the correct mapping for this error.


    Please execute the following to check what it means:
    db2diag -rc 0x8300045D


    And check for any errors logged in Windows logs.

Posting Permissions

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