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

[former_member227363]

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

[former_member227363]

Dear Hugo,

Still my facing same issue.( db2cklog )

Thanks

SANDEEP

[hugo_amo]

Sandeep,

Is 'test' the path where the archive logs are?

ARCHLOGPATH archive-log-path

Specifies a relative or an absolute path where the archive log files are stored. The default path is the current directory.

Regards,

Hugo

[Former Member]

Hello,

Please check your PATH system or user env variable. It looks like your PATH variable does not include  an appropriate path for DB2 binaries (e.g. ...\SQLLIB\bin). Or you can specify the absolute path of db2cklog instead.

Regards,

Masako

[hugo_amo]

Hi Sandeep,

Is the issue fixed? If so, please mark this thread as answered at your earliest opportunity.

Regards,

Hugo

[hugo_amo]

Hi Sandeep,

Please, close this thread if the issue is fixed.

Regards,

Hugo

[former_member227363]

Dear Hugo,

Sorry for trouble, but db2cklog command is not work.

Can you suggest me,whats wrong i m doing?

Thanks

SANDEEP

[hugo_amo]

Hi Sandeep,

if you have a look at the link I provided, you will see that you need to enter the log number, so it should be something like:

db2cklog CHECK 8036 ARCHLOGPATH test

Regards,

Hugo

[former_member227363]

Dear Hugo,

Please find the attachment.

Thanks

SANDEEP

db2diag.txt.zip

[hugo_amo]

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/r005852...

Hope this helps.

Regards,

Hugo

[former_member227363]

Dear Hugo,

Please find the screenshot.

Thanks

SANDEEP

[hugo_amo]

Hi Sandeep,

Would it be possible for you to attach the complete db2diag.log entries from today?

Regards,

Hugo

[hugo_amo]

Hi Sandeep,

Can you supply the output of 'db2level' command?

Regards,

Hugo