IDS Forum

RE: Logical Logs

Posted By: Penza Kenneth at MITTS
Date: Thursday, 6 December 2007, at 6:34 a.m.

In Response To: Logical Logs (CEDRIC CHIU)

A log flagged D was deleted and in order for it to be removed,
you just need to run a backup using ontape or onbar and they will go
away. The LOGSIZE and LOGFILES in the $ONCONFIG are only taken into
account when the instance is first initialized (oninit -i) afterwards
they are ignored.

The way to resize your logs is to use onparams to drop the logs
and recreate them with the new size, typically as shown below:

onparams -d -l 4 -y
onparams -d -l 5 -y
onparams -d -l 6 -y
ontape -s ( to delete to logs 1 to 6 after a Level 0 archive)
onparams -a -d <DBspace> 16384 (run it for 5 times) to create the new
logs
To drop logs 7 to 34 you may need to use onmode -l and onmode -c to be
able to delete them. Logs that contain the checkpoint record or current
logical logs cannot be deleted, thus you will need to use onmode -l or
onmode -c.
ontape -s (to delete to logs after a Level 0 archive)
Add the new logs with required size using
onparams -a -d <DBspace> 16384 (run it for 29 times)

Hope this clarifies the matter.

Regards,
Kenneth Penza
Systems Engineer
Systems and Database Services
Service Management Department
Malta Information Technology & Training Services Ltd

Please read our Legal Notice: http://emailpolicy.mitts.gov.mt

P
Please consider your environmental responsibility before printing this
e-mail.
END OF TEXT

-----Original Message-----
From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of
CEDRIC CHIU
Sent: 06 December 2007 08:48
To: ids@iiug.org
Subject: Logical Logs [10619]

Hi All Gurus,

I'm new to this forum and IDS. Please advise me how to remove/delete the

logical logs No.1 till No.3 from onstat -l, i assume flag D indicates
DELETE (
pls corret me if wrong)

And would it possible to readjust LOGSIZE to smaller value say "16384"
from
any available IDS tool.

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-1 0 128 6 1 6.00

phybegin physize phypos phyused %used

3:53 1048522 3486 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 128 463 74 57 6.3 1.3

Subsystem numrecs Log Space used

OLDRSAM 463 47244

address number flags uniqid begin size used %used
c00000001c452fb0 1 D------ 0 1:8455 32768 0 0.00
c00000001c1f14b0 2 D------ 0 1:41223 32768 0 0.00
c00000001c1f1518 3 D------ 0 1:73991 32768 0 0.00
c00000001c1f1580 4 U-B---- 69 2:53 32768 1 0.00
c00000001c1f15e8 5 U-B---- 70 2:32821 32768 1 0.00
c00000001c1f1650 6 U---C-- 71 2:65589 32768 1 0.00
c00000001c1f16b8 7 U-B---- 41 2:98357 32768 1 0.00
c00000001c1f1720 8 U-B---- 42 2:131125 32768 1 0.00
c00000001c1f1788 9 U-B---- 43 2:163893 32768 1 0.00
c00000001c1f17f0 10 U-B---- 44 2:196661 32768 1 0.00
c00000001c1f1858 11 U-B---- 45 2:229429 32768 1 0.00
c00000001c1f18c0 12 U-B---- 46 2:262197 32768 1 0.00
c00000001c1f1928 13 U-B---- 47 2:294965 32768 1 0.00
c00000001c1f1990 14 U-B---- 48 2:327733 32768 1 0.00
c00000001c1f19f8 15 U-B---- 49 2:360501 32768 1 0.00
c00000001c1f1a60 16 U-B---- 50 2:393269 32768 1 0.00
c00000001c1f1ac8 17 U-B---- 51 2:426037 32768 1 0.00
c00000001c1f1b30 18 U-B---- 52 2:458805 32768 1 0.00
c00000001c1f1b98 19 U-B---- 53 2:491573 32768 1 0.00
c00000001c1f1c00 20 U-B---- 54 2:524341 32768 1 0.00
c00000001c1f1c68 21 U-B---- 55 2:557109 32768 1 0.00
c00000001c1f1cd0 22 U-B---- 56 2:589877 32768 1 0.00
c00000001c1f1d38 23 U-B---- 57 2:622645 32768 1 0.00
c00000001c1f1da0 24 U-B---- 58 2:655413 32768 1 0.00
c00000001c1f1e08 25 U-B---- 59 2:688181 32768 1 0.00
c00000001c1f1e70 26 U-B---- 60 2:720949 32768 1 0.00
c00000001c1f1ed8 27 U-B---- 61 2:753717 32768 1 0.00
c00000001c1f1f40 28 U-B---- 62 2:786485 32768 1 0.00
c00000001c1f1fa8 29 U-B---- 63 2:819253 32768 1 0.00
c00000001d2b4028 30 U-B---- 64 2:852021 32768 1 0.00
c00000001d2b4090 31 U-B---- 65 2:884789 32768 1 0.00
c00000001d2b40f8 32 U-B---- 66 2:917557 32768 1 0.00
c00000001d2b4160 33 U-B---- 67 2:950325 32768 1 0.00
c00000001d2b41c8 34 U-B---L 68 2:983093 32768 2 0.01
31 active, 34 total

Hope to hear from.

Regards,

************************************************************************
*******
Forum Note: Use "Reply" to post a response in the discussion forum.

Messages In This Thread

• Logical Logs
  CEDRIC CHIU -- Thursday, 6 December 2007, at 2:47 a.m.
  • Re: Logical Logs
    John Miller iii -- Thursday, 6 December 2007, at 3:06 a.m.
  • RE: Logical Logs
    Penza Kenneth at MITTS -- Thursday, 6 December 2007, at 6:34 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.