DB logs full..Need to find which process making it?

[former_member201054]

Hi ,

In our PI 7.4 system, the db logs getting full and performance goes down suddenly

How to find which process/application making it to happen.

database is db2 10.5

I would appreciate your inputs for analysis.

Thanks in advance

[divyanshu_srivastava3]

Check diag log and take application snapshot of DB.

Mao the app ID with PID.

You will get an idea.

Note 1293475 - DB6: Transaction Log Full

Note 1308895 - DB6: File System for Transaction Log is Full

Regards,

[former_member201054]

Both the notes are unavailable to read.

[former_member201054]

I meant db2 archive log file system was getting full.

[Sriram2009]

Hi Daniel

Could you refer the SAP KBA for your issue

2141933 - DB6: How to initially trouble shoot transaction log full issue

BR

SS

[Former Member]

Hi Daniel,

At SAP level....

Goto ST04 --> choose Logging tab check the value for "Application with Oldest Transaction" this will give you the db2 application handle. Record the number.

Now click on Application from the left hand side panel in ST04 and search of the number in the Appl. handle column, once found double click on the number and you have all the required details...

PID: work process id.

Workstation: SAP application server on which the work process is running,

Application: Type of work process... and so on...

At OS level....

1. Command to get the current secondary log allocation
db2 get snapshot for database on <DBSID> | grep -i 'allocated currently'

2. Command to get the details on oldest transaction consuming secondary log
db2 get snapshot for database on <DBSID> | grep -i oldest

3. Command to get the details on the work process consuming secondary log

db2 get snapshot for application agentid xxxxx | grep -i  'Process ID'

here xxxx is the value obtained after running second command

Hope this is what you're looking for.

Regards,

Prithiviraj.

[manumohandas82]

Hi Daniel ,

Is is the compression on the archive logs enabled ?

IBM Knowledge Center

Thanks ,

Manu

[manumohandas82]

Hi Daniel ,

When you say db logs is it the  db2dump  ( trace file ) directory or is it  archive log / primary  [ log primary ]  log files . .

Is archiving logging turned on ?

Thanks ,

Manu

[divyanshu_srivastava3]

Map Agent ID with PID of SAP, you will get to know more on it.