Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

db2 archiving struck

Hello All,

I have limited knowledge on db2 database

PRD system 22TB database size

Linux OS

In our Production system ,  /db2/PRD/log_dir/NODE0000/LOGSTREAM0000/

has 700 files accumalated.

/db2/PRD/log_dir  is used by 99% ,

The number of Primary log files configured is 256 files.

since 12 hours the number of files  /db2/PRD/log_dir/NODE0000/LOGSTREAM0000/  remain 700

the rate of archiving is 60 to 80mb/second

questions

1. is it a db2 issue ? as claimed by Back up and Recover team

2. we suspect archiving is not happening , TSM is not moving the file   - we ERP Team claim this

TSM has to archive these files , is this understanding correct ?

The rate of Generation of log files by db2 is more , compared to archiving , hence we see 700 files since 12 hours.

Please suggest how to come our of this situation , if we leave system like this for next 4hours,

system will go'es  down  it will be huge impact

Thanks in advance

Former Member
Not what you were looking for? View more on this topic or Ask a question