Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2009
    Posts
    3

    Unanswered: Physical log files in DB2 growing up in size

    The database space came down to 42% from 97%, after truncating the table.So it appears although the table rows are deleted the physical file is unaffected, but on a truncate it wipes out everything.

    The 2.5 gig file came down to 26 kb after the truncate.

    why the physical file is never cleared eventhough the related table rows are deleted.

    -rw------- 1 inst01 db2adm 262144 Apr 03 06:30 /inst01/NODE0000/SQL00005/SQLT0002.0/SQL00113.LB
    -rw------- 1 inst01 db2adm 1583349760 Apr 03 06:30 inst01/NODE0000/SQL00007/SQLT0002.0/SQL00031.LB

    Kinldy advice wht needs to be done so the physical file never grows up in size and occupy much memory

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    what is the tablespace type sms or dms
    autoresize on yes/no
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Apr 2009
    Posts
    3
    The tablespace is SMS with autoresize set to YES

  4. #4
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by buchi
    The tablespace is SMS with autoresize set to YES
    That's not possible. AUTORESIZE does not make any sense for SMS tablespaces.
    ---
    "It does not work" is not a valid problem statement.

  5. #5
    Join Date
    Apr 2009
    Posts
    3
    how do i proceed with thinngs?

Posting Permissions

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