Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2002
    Location
    India
    Posts
    17

    Unanswered: Archive Log Files

    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.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Archive Log Files

    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

    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.

  3. #3
    Join Date
    Dec 2002
    Posts
    3

    Re: Archive Log Files

    Cheer,

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

    Thanks

    John

    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

  4. #4
    Join Date
    Sep 2002
    Posts
    456

    Re: Archive Log Files

    Try this..

    http://www.breakthroughdb2.com/backrec.html

    Paul

    Originally posted by JJX
    Cheer,

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

    Thanks

    John

  5. #5
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Archive Log Files

    I think dg_prune is a Unix Script ....

    Cheers

    Sathyaram

    Originally posted by dollar489
    Try this..

    http://www.breakthroughdb2.com/backrec.html

    Paul

  6. #6
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: Archive Log Files

    I would also check the ulimits for the db2 userid and any user accessing the system.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •