cancel
Showing results for 
Search instead for 
Did you mean: 

DB2, Log File has reached its saturation point" DIA8309C Log file was full,

Former Member
0 Kudos

Hello Experts,

I have successfully installed a ECC 6.0 System-ABAP + JAVA (DB2 v9.5 windows server 2008-x64 bit).

Kernel: 700 , Patch: 185 ; SP level : rel 700 , level 17.

However now i suddenly cannot connect to database and SAP is down.

C:\Users\dsqadm.DUCATI>r3trans -d

This is r3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = DB6 --- DB2DB

DFT = 'DSQ'"

r3trans finished (0012).

db2diag.log:-

______________________________________________________________________________________________________

ADM1823E The active log is full and is held by application handle "51886". Terminate this application by COMMIT, ROLLBACK or FORCE APPLICATION.

"Log File has reached its saturation point" DIA8309C Log file was full.

"Backup pending. Database has been made recoverable. Backup now required." DIA8168C Backup pending for database .

_______________________________________________________________________________________________________

Also, regarding DB2 licensing,i have a query:

db2licm -l gives the following:

______________________________________________________________________________-

C:\Users\db2dsq.DUCATI>db2licm -l

Product name: "DB2 Enterprise Server Edition"

License type: "CPU Option"

Expiry date: "Permanent"

Product identifier: "db2ese"

Version information: "9.5"

Enforcement policy: "Soft Stop"

Features:

DB2 Database Partitioning: "Licensed"

DB2 Performance Optimization ESE: "Licensed"

DB2 Storage Optimization: "Licensed"

DB2 Advanced Access Control: "Not licensed"

DB2 Geodetic Data Management: "Not licensed"

IBM Homogeneous Replication ESE: "Not licensed"

Product name: "DB2 Connect Server"

License type: "Trial"

Expiry date: "10/19/2009"

Product identifier: "db2consv"

Version information: "9.5"

_______________________________________________________________________________

I have applied both sap and DB2 license. Is everything ok regarding licensing of DB v9.5 for using with SAP?

I am new to DB2 database and looking for expert guidance regarding the above mentioned issues.

Thanks,

Rakesh

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

This is nice too:

SELECT DB_NAME AS "DB Name",

CASE (TOTAL_LOG_AVAILABLE)

WHEN -1 THEN DEC(-1,5,2)

ELSE DEC(100 * (FLOAT(TOTAL_LOG_USED)/FLOAT(TOTAL_LOG_USED + TOTAL_LOG_AVAILABLE)), 5,2) END AS "Log used %",

TOTAL_LOG_USED / 1024/1024 AS "Total log used/MB",

CASE (TOTAL_LOG_AVAILABLE)

WHEN -1 THEN -1

ELSE TOTAL_LOG_AVAILABLE / 1024/1024 END AS "Total log available/MB",

TOT_LOG_USED_TOP / 1024/ 1024 AS "Total log used TOP/MB",

APPL_ID_OLDEST_XACT AS "ID oldest transaction",

DBPARTITIONNUM

FROM SYSIBMADM.SNAPDB

Best regrads,

Joachim

Frank-Martin
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Rakesh,

first you should try to find out which application is holding the oldest transaction.

db2 get snapshot for applications on <DBNAME>

and look for application handle "51886".

This will show you, if its a Java or ABAP Stack related problem and may also give you more information based on the last executed SQL Statement and maybe the TPMON attributes in the snapshot.

To release the locks you can force the application from the database

db2 " force application ( 51886 ) "

But make sure that you capture the snapshot information first to get some hint about the root cause.

Regards

Frank

Former Member
0 Kudos

C:\Users\db2dsq.DUCATI>db2 get snapshot for applications on DSQ

SQL1611W No data was returned by Database System Monitor.

No clue from the above mentioned command. Kindly suggest.

Thanks,

Rakesh

Frank-Martin
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Rakesh,

are your monitoring switches turned on? SAP default settings are

> db2 get dbm cfg | grep MON

Transaction processor monitor name (TP_MON_NAME) =

Buffer pool (DFT_MON_BUFPOOL) = ON

Lock (DFT_MON_LOCK) = ON

Sort (DFT_MON_SORT) = ON

Statement (DFT_MON_STMT) = ON

Table (DFT_MON_TABLE) = ON

Timestamp (DFT_MON_TIMESTAMP) = ON

Unit of work (DFT_MON_UOW) = ON

Monitor health of instance and databases (HEALTH_MON) = OFF

Regards

Frank

Former Member
0 Kudos

C:\Users\db2dsq.DUCATI>db2 get dbm cfg

Database Manager Configuration

Node type = Enterprise Server Edition with local and remote clients

Database manager configuration release level = 0x0c00

Maximum total of files open (MAXTOTFILOP) = 16000

CPU speed (millisec/instruction) (CPUSPEED) = 4,723442e-007

Communications bandwidth (MB/sec) (COMM_BANDWIDTH) = 1,000000e+002

Max number of concurrently active databases (NUMDB) = 8

Federated Database System Support (FEDERATED) = NO

Transaction processor monitor name (TP_MON_NAME) =

Default charge-back account (DFT_ACCOUNT_STR) =

Default database monitor switches

Buffer pool (DFT_MON_BUFPOOL) = ON

Lock (DFT_MON_LOCK) = ON

Sort (DFT_MON_SORT) = ON

Statement (DFT_MON_STMT) = ON

Table (DFT_MON_TABLE) = ON

Timestamp (DFT_MON_TIMESTAMP) = ON

Unit of work (DFT_MON_UOW) = ON

Monitor health of instance and databases (HEALTH_MON) = OFF

0 Kudos

Hello,

in your initial post I have seen that you have posted another error message from db2diag.log.

"Backup pending. Database has been made recoverable. Backup now required." DIA8168C Backup pending for database .

Does this occur after the log file full message?

Maybe you problem is not related to the log fill condition.

As db2<sid> user, what does a "db2 connect to <sid>" command return?

Edited by: Hans-Juergen Moldowan on Sep 3, 2009 12:37 PM

Former Member
0 Kudos

C:\Users\db2dsq.DUCATI>db2 connect to dsq

SQL1116N A connection to or activation of database "DSQ" cannot be made

because of BACKUP PENDING. SQLSTATE=57019

0 Kudos

Hello,

most probably you recently have switched from DB2 circular logging to DB2 archival logging, e.g. by modifying the LOGARCHMETH1 DB CFG parameter.

After a DB2 restart this gets active and for security reasons DB2 ensures that an offline backup is taken.

That is exactly what is also mentioned in the SQL1116N - BACKUP PENDING.

You need to perform a full offline backup of your database.

Former Member
0 Kudos

i got this

Note 25832 - DB2/CS: Termination of R3trans -d aft. installation

Note 63616 - DB2/CS: SQL1136 upgr. phase ENDCHK; BACKUP PENDING..

lets me check.

thanks

rakesh

Former Member
0 Kudos

Rakesh,

You can run a full DB2 backup if it is absolutely necessary. However if you feel that backup is not necessary (i.e. this is being copied to a sandbox for testing purpose) there is a backdoor method to get the database out of backup pending.

Issue the following as the instance owner (db2<sid>):

db2dart <SID> /chst /what dbbp off

This will change the state of the database to backup-pending off.

Regards,

Sameer

0 Kudos

Hello,

please handle this with extreme care.

If you need to recover your database you only can perform a version restore to the state of your last backup before the db2dart command.

Therefore I recommend the backup option.

If you are using the db2dart, please make sure to perform a full offline backup asap.

More information on performing backups can be found here:

[A Practical Guide to Backup and Recovery of IBM DB2 for Linux, UNIX and Windows in SAP Environments Part 1: Backup and Recovery - Overview|https://www.sdn.sap.com/irj/sdn/db6?rid=/library/uuid/80e61772-e471-2c10-60b1-9529b69b50c5]

Former Member
0 Kudos

Issue resolved by following the recommendations of "Note 25832 - DB2/CS: Termination of R3trans -d aft. installation"

Thanks a lot for your help