Skip to Content

DB2 error: ADM14001C An unexpected and critical error has occurre !!!

Hi Expert,

i am getting error while activating the db2 database, my SAP dispatcher is down.

Please give your valuable solutions.

Db2diag.log ::

2015-10-03-12.49.02.049000+330 I1415582F485 LEVEL: Error

PID : 772 TID : 3216 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

EDUID : 3216 EDUNAME: db2loggr (RSQ) 0

FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:220

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2015-10-03-12.49.02.049000+330 I1416069F610 LEVEL: Error

PID : 772 TID : 3216 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

EDUID : 3216 EDUNAME: db2loggr (RSQ) 0

FUNCTION: DB2 UDB, data protection services, sqlpgolf, probe:220

MESSAGE : Filename :

DATA #1 : Hexdump, 40 bytes

0x000000001021F108 : 463A 5C64 6232 5C52 5351 5C6C 6F67 5F64 F:\db2\RSQ\log_d

0x000000001021F118 : 6972 5C4E 4F44 4530 3030 305C 5330 3030 ir\NODE0000\S000

0x000000001021F128 : 3830 3336 2E4C 4F47 8036.LOG

2015-10-03-12.49.02.049000+330 I1416681F386 LEVEL: Error

PID : 772 TID : 3216 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

EDUID : 3216 EDUNAME: db2loggr (RSQ) 0

FUNCTION: DB2 UDB, data protection services, sqlpgole, probe:1710

MESSAGE : Error -2079391743 opening database log extent 8036:

2015-10-03-12.49.02.049000+330 I1417069F499 LEVEL: Severe

PID : 772 TID : 3216 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

EDUID : 3216 EDUNAME: db2loggr (RSQ) 0

FUNCTION: DB2 UDB, data protection services, sqlpgInitRecoverable, probe:1480

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2015-10-03-12.49.02.049000+330 I1417570F491 LEVEL: Error

PID : 772 TID : 3216 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

EDUID : 3216 EDUNAME: db2loggr (RSQ) 0

FUNCTION: DB2 UDB, data protection services, sqlpgLoggrInit, probe:430

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2015-10-03-12.49.02.065000+330 I1418063F162 LEVEL: Error

PID:772 TID:3216 NODE:000 Title: SQLP_DBCB

Dump File:\\rsclqas\db2dumpRSQ\772.3216.000.dump.bin

2015-10-03-12.49.02.080000+330 I1418227F376 LEVEL: Severe

PID : 772 TID : 3216 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

EDUID : 3216 EDUNAME: db2loggr (RSQ) 0

FUNCTION: DB2 UDB, data protection services, sqlpgasn, probe:4000

MESSAGE : Logging can not continue due to an error.

2015-10-03-12.49.02.096000+330 I1418605F592 LEVEL: Severe

PID : 772 TID : 3804 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

APPHDL : 0-18 APPID: fe80::c4:2406:d4f4:ddbe%26.54916.151003071856

AUTHID : SAPRSQ

EDUID : 3804 EDUNAME: db2agent (RSQ) 0

FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:9030

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2015-10-03-12.49.02.096000+330 I1419199F592 LEVEL: Severe

PID : 772 TID : 3804 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

APPHDL : 0-18 APPID: fe80::c4:2406:d4f4:ddbe%26.54916.151003071856

AUTHID : SAPRSQ

EDUID : 3804 EDUNAME: db2agent (RSQ) 0

FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:3600

RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

DIA8701C Access denied for resource "", operating system return code

was "".

2015-10-03-12.49.02.096000+330 I1419793F519 LEVEL: Severe

PID : 772 TID : 3804 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

APPHDL : 0-18 APPID: fe80::c4:2406:d4f4:ddbe%26.54916.151003071856

AUTHID : SAPRSQ

EDUID : 3804 EDUNAME: db2agent (RSQ) 0

FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120

DATA #1 : Hexdump, 4 bytes

0x000000000F421DFC : 0100 0F84 ....

2015-10-03-12.49.02.096000+330 I1420314F518 LEVEL: Error

PID : 772 TID : 3804 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

APPHDL : 0-18 APPID: fe80::c4:2406:d4f4:ddbe%26.54916.151003071856

AUTHID : SAPRSQ

EDUID : 3804 EDUNAME: db2agent (RSQ) 0

FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120

DATA #2 : Hexdump, 4 bytes

0x000000000F421DFC : 0100 0F84 ....

2015-10-03-12.49.02.096000+330 E1420834F985 LEVEL: Critical

PID : 772 TID : 3804 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

APPHDL : 0-18 APPID: fe80::c4:2406:d4f4:ddbe%26.54916.151003071856

AUTHID : SAPRSQ

EDUID : 3804 EDUNAME: db2agent (RSQ) 0

FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10

MESSAGE : ADM14001C An unexpected and critical error has occurred:

"DBMarkedBad". The instance may have been shutdown as a result.

"Automatic" FODC (First Occurrence Data Capture) has been invoked and

diagnostic information has been recorded in directory

"\\rsclqas\db2dumpRSQ\FODC_DBMarkedBad_2015-10-03-12.49.02.096000\".

Please look in this directory for detailed evidence about what

happened and contact IBM support if necessary to diagnose the

problem.

2015-10-03-12.49.02.096000+330 E1421821F483 LEVEL: Severe

PID : 772 TID : 3804 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

APPHDL : 0-18 APPID: fe80::c4:2406:d4f4:ddbe%26.54916.151003071856

AUTHID : SAPRSQ

EDUID : 3804 EDUNAME: db2agent (RSQ) 0

FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10

MESSAGE : ADM7518C "RSQ " marked bad.

2015-10-03-12.49.02.127000+330 I1422306F633 LEVEL: Event

PID : 772 TID : 3804 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

APPHDL : 0-18 APPID: fe80::c4:2406:d4f4:ddbe%26.54916.151003071856

AUTHID : SAPRSQ

EDUID : 3804 EDUNAME: db2agent (RSQ) 0

FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::MarkDBBad, probe:10

STOP : AUTOMATIC FODC : DBMarkedBad : success

IMPACT : None

DATA #1 : String, 99 bytes

Check \\rsclqas\db2dumpRSQ\FODC_DBMarkedBad_2015-10-03-12.49.02.096000\ for diagnostic information.

2015-10-03-12.49.02.127000+330 I1422941F541 LEVEL: Severe

PID : 772 TID : 3804 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

APPHDL : 0-18 APPID: fe80::c4:2406:d4f4:ddbe%26.54916.151003071856

AUTHID : SAPRSQ

EDUID : 3804 EDUNAME: db2agent (RSQ) 0

FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:125

DATA #1 : Hexdump, 4 bytes

0x000007FFFDF0B554 : EEFB FFFF ....

2015-10-03-12.49.02.158000+330 E1423484F493 LEVEL: Event

PID : 772 TID : 3804 PROC : db2syscs.exe

INSTANCE: DB2RSQ NODE : 000 DB : RSQ

APPHDL : 0-18 APPID: fe80::c4:2406:d4f4:ddbe%26.54916.151003071856

AUTHID : SAPRSQ

EDUID : 3804 EDUNAME: db2agent (idle) 0

FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::TermDbConnect, probe:2000

STOP : DATABASE: RSQ : DEACTIVATED: NO

Regards

SANDEEP

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Oct 03, 2015 at 09:37 AM

    Hi Sandeep,

    Can you supply the output of 'db2level' command?

    Regards,

    Hugo

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 03, 2015 at 09:41 AM

    Dear Hugo,

    Please find the screenshot.

    Thanks

    SANDEEP


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 03, 2015 at 10:29 AM

    Dear Hugo,

    Please find the attachment.

    Thanks

    SANDEEP


    db2diag.txt.zip (40.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

    • Thanks Sandeep,

      I saw:

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

      2015-10-02-23.11.15.851000+330 I456174F412 LEVEL: Error

      PID : 3244 TID : 3432 PROC : db2syscs.exe

      INSTANCE: DB2RSQ NODE : 000

      EDUID : 3432 EDUNAME: db2logmgr (RSQ) 0

      FUNCTION: DB2 UDB, data protection services, sqlpgAllocateLogFile, probe:4500

      RETCODE : ZRC=0x850F000C=-2062614516=SQLO_DISK "Disk full."

      DIA8312C Disk was full.

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

      So, please make sure that there is free space in the database.

      This error:

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

      RETCODE : ZRC=0x840F0001=-2079391743=SQLO_ACCD "Access Denied"

      DIA8701C Access denied for resource "", operating system return code

      was "".

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

      indicates that the database attempted to write to a read-only file. As for this case, the log file S0008036.LOG didn't have the correct

      permission to be accessed during the database required write access on it.

      Ensure all the database files and log files have the correct permissions including user/group rights to be accessed and please also check if log file S0008036.LOG is located in the directory:

      F:\db2\RSQ\log_dir\NODE0000\ and it could be accessed from operating system level, please also check what permission is set for this log

      file.

      Run db2cklog command for the log S0008036.LOG

      Here is link for command and example :

      http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0058520.html

      Hope this helps.

      Regards,

      Hugo

  • Posted on Oct 03, 2015 at 11:06 AM

    Dear Hugo,

    Sorry for trouble, but db2cklog command is not work.

    Can you suggest me,whats wrong i m doing?

    Thanks

    SANDEEP


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 03, 2015 at 11:37 AM

    Dear Hugo,

    Still my facing same issue.( db2cklog )

    Thanks

    SANDEEP


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.