Archive Log Files

dkhambit · #1 (**permalink**) 01-16-02, 02:00

Hi All,
We are using DB2 UDB AIX . Actually , we are short of memory on the filesystem on which Database resides. The log file path is /portals/novainst/novainst/NODE0000/SQL00003/SQLOGDIR/

Also there are ,lot of previous lofs available which are consuming enough amount of memory.
Can I delete these old log files?
Will it cause the database to crash? If deletion is permitted, what files , I mean what are the considerations we have to keep in mind?
COldBacks are done monthly basis and online backup on daily basis.

Also if someone can enlighten my views on logging process, it will be great help. Like what is the logging process and how is done in DB2 AIX. ? What are the primary and secondary logs?

To add to my queries, I am getting messages in Diag file like :

SMS Tablespace 1(TEMPSPACE1) is FULL or file is too large (at OS or user limit).Detected on Container 0. ContPage= 72169l Obj=9 Type=128

2001-06-04-13.21.40.213064 Instance:novainst Node:000
PID:26018(db2agent (TATADB)) Appid:C0A80174.BDF7.010601133747
buffer_pool_services sqlbWritePageToContainer Probe:20 Database:TATADB

SMS Tablespace 1(TEMPSPACE1) is FULL or file is too large (at OS or user limit).
Detected on Container 0. ContPage= 72700l Obj=9 Type=128
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:thd_table
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:thd_table->size
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:real_size(3)
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:the_section

SO is it doing everything automatically.? WIll it cause some problems to database?

Thanks in advance,
Deven.

sathyaram_s · #2 (**permalink**) 01-16-02, 06:12

Deven

'Data Recovery and High Availabiltiy guide and Reference' at
http://www-4.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

is the best place to look at for all backup/recovery details including logging.

In Database-guys Inc website, there is a script for download. This is called db_prune which will help you to decide and prune unwanted logfiles, recovery history and backups. You can use this script as the starting point for pruning.

Hope this helps

Cheers

Sathyaram

Quote:

Originally posted by dkhambit
Hi All,
We are using DB2 UDB AIX . Actually , we are short of memory on the filesystem on which Database resides. The log file path is /portals/novainst/novainst/NODE0000/SQL00003/SQLOGDIR/

Also there are ,lot of previous lofs available which are consuming enough amount of memory.
Can I delete these old log files?
Will it cause the database to crash? If deletion is permitted, what files , I mean what are the considerations we have to keep in mind?
COldBacks are done monthly basis and online backup on daily basis.

Also if someone can enlighten my views on logging process, it will be great help. Like what is the logging process and how is done in DB2 AIX. ? What are the primary and secondary logs?

To add to my queries, I am getting messages in Diag file like :

SMS Tablespace 1(TEMPSPACE1) is FULL or file is too large (at OS or user limit).Detected on Container 0. ContPage= 72169l Obj=9 Type=128

2001-06-04-13.21.40.213064 Instance:novainst Node:000
PID:26018(db2agent (TATADB)) Appid:C0A80174.BDF7.010601133747
buffer_pool_services sqlbWritePageToContainer Probe:20 Database:TATADB

SMS Tablespace 1(TEMPSPACE1) is FULL or file is too large (at OS or user limit).
Detected on Container 0. ContPage= 72700l Obj=9 Type=128
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:thd_table
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:thd_table->size
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:real_size(3)
Dump File:/portals/novainst/sqllib/db2dump/43598.000 Data:the_section

SO is it doing everything automatically.? WIll it cause some problems to database?

Thanks in advance,
Deven.

JJX · #3 (**permalink**) 12-06-02, 15:09

Cheer,

Where can find db_proune? cause I have the same issue on WIN platform.

Thanks

John

Quote:

Originally posted by sathyaram_s
Deven

'Data Recovery and High Availabiltiy guide and Reference' at
http://www-4.ibm.com/cgi-bin/db2www/...bs.d2w/en_main

is the best place to look at for all backup/recovery details including logging.

In Database-guys Inc website, there is a script for download. This is called db_prune which will help you to decide and prune unwanted logfiles, recovery history and backups. You can use this script as the starting point for pruning.

Hope this helps

Cheers

Sathyaram