Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2015
    Posts
    17

    Unanswered: 2nd set of Diag messages

    Hello All,

    Below is second set of Diag messages. Can you please help understand the issue (if any). Our application processing got very low during this time period.

    2015-10-29-11.09.47.729533+330 I29008070A544 LEVEL: Severe
    PID : 1966518 TID : 43521 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB :
    APPHDL : 0-58463 APPID: *LOCAL.db2inst1.151026222311
    AUTHID : DB2INST1 HOSTNAME: nowdbprod
    EDUID : 43521 EDUNAME: db2agent (instance) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleForceAgents, probe:15
    DATA #1 : Hexdump, 4 bytes
    0x07000019FAFF5010 : 0000 04CE ....

    2015-10-29-11.11.54.775705+330 E29008615A428 LEVEL: Info
    PID : 1966518 TID : 3723 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : NOWPROD
    HOSTNAME: nowdbprod
    EDUID : 3723 EDUNAME: db2logmgr (NOWPROD) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
    DATA #1 : <preformatted>
    Started archive for log file S0064494.LOG.

    2015-10-29-11.11.59.635123+330 I29009044A537 LEVEL: Info
    PID : 1966518 TID : 3723 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : NOWPROD
    HOSTNAME: nowdbprod
    EDUID : 3723 EDUNAME: db2logmgr (NOWPROD) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
    DATA #1 : <preformatted>
    Completed archive for log file S0064494.LOG to XX

    2015-10-29-11.12.49.933992+330 I29009582A544 LEVEL: Severe
    PID : 1966518 TID : 43521 PROC : db2sysc 0
    FUNCTION: DB2 UDB, base sys utilities, sqleForceAgents, probe:15
    DATA #1 : Hexdump, 4 bytes
    0x07000019FAFF5010 : 0000 04CE ....

    2015-10-29-11.16.29.666978+330 E29010127A428 LEVEL: Info
    PID : 1966518 TID : 3723 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : NOWPROD
    HOSTNAME: nowdbprod
    EDUID : 3723 EDUNAME: db2logmgr (NOWPROD) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
    DATA #1 : <preformatted>
    Started archive for log file S0064495.LOG.

    2015-10-29-11.16.34.281077+330 I29010556A537 LEVEL: Info
    PID : 1966518 TID : 3723 PROC : db2sysc 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
    DATA #1 : <preformatted>
    Completed archive for log file S0064495.LOG to YY

    2015-10-29-11.17.54.752090+330 I29011094A508 LEVEL: Warning
    PID : 1966518 TID : 70204 PROC : db2sysc 0
    FUNCTION: DB2 UDB, database monitor, sqm___sqm_snap_db_locks, probe:100
    MESSAGE : Lock monitoring output may be incomplete.

    2015-10-29-11.21.21.021273+330 I29011603A544 LEVEL: Severe
    PID : 1966518 TID : 43521 PROC : db2sysc 0
    FUNCTION: DB2 UDB, base sys utilities, sqleForceAgents, probe:15
    DATA #1 : Hexdump, 4 bytes
    0x07000019FAFF5010 : 0000 04CE ....

    2015-10-29-11.23.22.066495+330 I29012148A544 LEVEL: Severe
    PID : 1966518 TID : 43521 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB :
    APPHDL : 0-58463 APPID: *LOCAL.db2inst1.151026222311
    AUTHID : DB2INST1 HOSTNAME: nowdbprod
    EDUID : 43521 EDUNAME: db2agent (instance) 0
    FUNCTION: DB2 UDB, base sys utilities, sqleForceAgents, probe:15
    DATA #1 : Hexdump, 4 bytes
    0x07000019FAFF5010 : 0000 04CE ....

    2015-10-29-11.26.19.360026+330 E29012693A1532 LEVEL: Warning
    PID : 1704258 TID : 772 PROC : db2acd 0
    INSTANCE: db2inst1 NODE : 000
    HOSTNAME: nowdbprod
    EDUID : 772 EDUNAME: db2acd 0
    FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
    MESSAGE : ADM10501W Health indicator "Database Automatic Storage Utilization"
    ("db.auto_storage_util") breached the "upper" warning threshold of
    "80 %" with value "80 %" on "database" "db2inst1.NOWPROD ".

    2015-10-29-11.28.02.588950+330 I29014226A1206 LEVEL: Error
    PID : 1966518 TID : 46889 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : NOWPROD
    APPHDL : 0-32645 APPID: AAAAAAAAAAAAAAAAAAAAAAAAAAAAAa
    AUTHID : DB2INST1 HOSTNAME: nowdbprod
    EDUID : 46889 EDUNAME: db2agent (NOWPROD) 0
    FUNCTION: DB2 UDB, sort/list services, sqlsFetchNextTempRecord, probe:504
    MESSAGE : ZRC=0x80040003=-2147221501=SQLD_INTRP "USER INTERRUPT DETECTED"
    DIA8003C The interrupt has been received.
    DATA #1 : Codepath, 8 bytes
    8
    DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes
    0x80040003
    DATA #3 : SQLS_MBUFS, PD_TYPE_SQLS_MBUFS, 1720 bytes

    SQLS_MBUFS: Address:7000031d5805578, Size:x6b8, Size:1720
    x0688 pValues 7000031cbf6d8a0
    x0690 recptr 7000031cbf6d780
    x06AC records 33827
    x0698 recordBuffer 7000031cbf6d780
    x06A0 iNumBufferedRecords 0
    x06A8 mergeFlags x00000002
    - SQLS_CALLED_FETCH_NEXT_TEMP_REC
    x06B0 sortNum 0
    x06B4 bufferedFetchRC -2147221501

    2015-10-29-11.28.11.747018+330 E29015433A1116 LEVEL: Error
    PID : 1966518 TID : 46889 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : NOWPROD
    APPHDL : 0-32645 APPID: AA
    AUTHID : DB2INST1 HOSTNAME: nowdbprod
    EDUID : 46889 EDUNAME: db2agent (NOWPROD) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_rds_common_post, probe:870
    MESSAGE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : String, 28 bytes
    UCstate terminate bit is set
    DATA #2 : Hexdump, 4 bytes
    0x00000002C5B7BE28 : 0000 01D8 ....
    DATA #3 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLRRRCP
    sqlerrd : (1) 0x80040003 (2) 0x00000003 (3) 0x00000000
    (4) 0x00000000 (5) 0xFFFFEC0A (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:

    2015-10-29-11.30.16.542987+330 E29016550A428 LEVEL: Info
    PID : 1966518 TID : 3723 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : NOWPROD
    HOSTNAME: nowdbprod
    EDUID : 3723 EDUNAME: db2logmgr (NOWPROD) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3108
    DATA #1 : <preformatted>
    Started archive for log file S0064496.LOG.

    2015-10-29-11.30.20.847518+330 I29016979A537 LEVEL: Info
    PID : 1966518 TID : 3723 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : NOWPROD
    HOSTNAME: nowdbprod
    EDUID : 3723 EDUNAME: db2logmgr (NOWPROD) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgArchiveLogFile, probe:3180
    DATA #1 : <preformatted>
    Completed archive for log file S0064496.LOG to XX

    2015-10-29-11.30.49.039837+330 I29017517A1199 LEVEL: Error
    PID : 1966518 TID : 82775 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : NOWPROD
    APPHDL : 0-34902 APPID: AAAAAAAAAAAAAAAAAAAAAAAAAAAAAa
    AUTHID : DB2INST1 HOSTNAME: nowdbprod
    EDUID : 82775 EDUNAME: db2agent (NOWPROD) 0
    FUNCTION: DB2 UDB, sort/list services, sqlsFetchNextTempRecord, probe:504
    MESSAGE : ZRC=0x80130003=-2146238461=SQLS_INTRP "Interrupt. User Cancel."
    DIA8003C The interrupt has been received.
    DATA #1 : Codepath, 8 bytes
    1
    DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes
    0x80130003
    DATA #3 : SQLS_MBUFS, PD_TYPE_SQLS_MBUFS, 1720 bytes

    SQLS_MBUFS: Address:70000318238f160, Size:x6b8, Size:1720
    x0688 pValues 7000031a36501e8
    x0690 recptr 7000031a3650080
    x06AC records 132037
    x0698 recordBuffer 7000031a3650080
    x06A0 iNumBufferedRecords 2
    x06A8 mergeFlags x00000002
    - SQLS_CALLED_FETCH_NEXT_TEMP_REC
    x06B0 sortNum 0
    x06B4 bufferedFetchRC 0

    2015-10-29-11.30.50.820508+330 E29018717A1117 LEVEL: Error
    PID : 1966518 TID : 82775 PROC : db2sysc 0
    INSTANCE: db2inst1 NODE : 000 DB : NOWPROD
    APPHDL : 0-34902 APPID: AAA
    AUTHID : DB2INST1 HOSTNAME: nowdbprod
    EDUID : 82775 EDUNAME: db2agent (NOWPROD) 0
    FUNCTION: DB2 UDB, relation data serv, sqlrr_rds_common_post, probe:870
    MESSAGE : ZRC=0x8012006D=-2146303891=SQLR_CA_BUILT
    "SQLCA has already been built"
    DATA #1 : String, 28 bytes
    UCstate terminate bit is set
    DATA #2 : Hexdump, 4 bytes
    0x0000000124ADFE88 : 0000 01D8 ....
    DATA #3 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
    sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1224 sqlerrml: 0
    sqlerrmc:
    sqlerrp : SQLRRRCP
    sqlerrd : (1) 0x80130003 (2) 0x00000003 (3) 0x00000000
    (4) 0x00000000 (5) 0xFFFFEC0A (6) 0x00000000
    sqlwarn : (1) (2) (3) (4) (5) (6)
    (7) (8) (9) (10) (11)
    sqlstate:


    Thanks & Regards,
    Dhiraj

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    what about db2 level and platform (read before posting)
    what about userid/password to reach your system, so we can have a look
    with provided info : nothing can be done..
    describe problem/issue
    we do not provide complete solutions for free..
    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

Posting Permissions

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