Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2013
    Posts
    1

    Unanswered: DB2 related issue when I take LDAP backup

    Hi,

    I have a job which take backup of ldap(ldf format). It was running properly without any issues. Recently, it creates backup file with 0kb. When I run the job manually I have got the error message “GLPRDB001E Error code -1 from function:" SQLConnect " <DBName> .”. When I have checked the db2diag.log file I have got the below messages.

    db2diag.log:
    ============
    ************************************************** ************************************************** ***********
    2013-03-04-05.36.20.591000-300 E34198451H363 LEVEL: Error (OS)
    PID : 2416 TID : 2832 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, oper system services, sqloImpersonateLocalSystem, probe:10
    MESSAGE : ZRC=0x83000005=-2097151995
    CALLED : OS, -, OpenProcess
    OSERR : 5 "Access is denied."

    2013-03-04-05.36.20.591000-300 I34198816H282 LEVEL: Severe
    PID : 2416 TID : 2832 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:20
    RETCODE : ZRC=0x83000005=-2097151995

    2013-03-04-05.36.20.606000-300 I34199100H350 LEVEL: Severe
    PID : 2416 TID : 2832 PROC : db2syscs.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, trace services, sqlt_logerr_data, probe:0
    MESSAGE : User ID
    DATA #1 : Hexdump, 4 bytes
    0x02B7FAC0 : 0000 0000 ....

    2013-03-04-05.36.20.606000-300 I34199452H466 LEVEL: Severe
    PID : 2856 TID : 3032 PROC : db2fmp.exe
    INSTANCE: DB2 NODE : 000
    FUNCTION: DB2 UDB, DRDA Communication Manager, sqljcCommConnect, probe:10
    MESSAGE : ZRC=0x82360001=-2110390271=SQLJC_ERROR_ICE "SYSTEM ERROR"
    DIA8532C An internal processing error has occurred.
    DATA #1 : String, 11 bytes
    CCI Error:
    DATA #2 : unsigned integer, 4 bytes
    81
    ************************************************** ************************************************** ***********

    When I have tried to connect to the respective database from db2control center am gettting the below error.

    ************************************************** ************************************************** ***********
    A system error (reason code = "") occurred. Subsequent SQL
    statements cannot be processed. SQLSTATE=58005

    Explanation:

    A system error occurred.

    User Response:

    Record the message number (SQLCODE) and reason code in the
    message.

    If trace was active, invoke the Independent Trace Facility at
    the operating system command prompt. Then contact your technical
    service representative with the following information:

    o Problem description

    o SQLCODE and embedded reason code

    o SQLCA contents if possible

    o Trace file if possible.

    Federated system users: isolate the problem to the data source
    failing the request (refer to the problem determination guide to
    determine which data source is failing to process the SQL
    statement) and take the necessary diagnostic steps for that data
    source. The problem determination procedures for data sources
    vary, so refer to the applicable data source manuals.

    sqlcode : -902

    sqlstate : 58005
    ************************************************** ************************************************** ***********

    What could be the issue. Pls help on this.


    Thanks in Advance.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    looks severe..
    is ldap still working ?
    try local logon on db and try manual connect..
    in worse case .. stop ldap.. stop db2 and restart
    looks like os error
    CALLED : OS, -, OpenProcess
    OSERR : 5 "Access is denied."
    any changes on ulimit ?
    any message in system log ?
    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
  •