Re: experience in DB Adm
2002-07-18 09:21:13
Subject: |
Re: experience in DB Adm |
From: |
Jozef Zatko <zatko AT LOGIN DOT SK> |
Date: |
Thu, 18 Jul 2002 15:19:24 +0200 |
Hi Luciano,
in order to expand capacity of your database, you must (after creating db
volume) assign this new space to db with command:
extend db 1000
Ing. Jozef Zatko
Login a.s.
Dlha 2, Stupava
tel.: (421) (2) 60252618
Luciano Ariceto <Luciano.Ariceto AT IPAPERBR DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
18.07.2002 15:35
Please respond to "ADSM: Dist Stor Manager"
To: ADSM-L AT VM.MARIST DOT EDU
cc:
Subject: experience in DB Adm
Hi
Last weekend we had a problem with DB capacity as follow :
ANR0362W Database usage exceeds 98 % of its assigned capacity.
ANR0131E dftxn.c838: Server DB space exhausted.
ANR1181E dftxn.c200: Data storage transaction 0:424803852 was aborted.
After this, the TSM server "frozen" and we expanded de DB
ANR2017I Administrator ADMIN issued command: DEFINE DBVOLUME
f:\tivoli\db\db05.tsm FORMATSIZE=1000 WAIT=NO ANR0984I Process 14 for
DEFINE DBVOLUME started in the BACKGROUND at 04:57:46.
ANR2491I Volume Creation Process starting for f:\tivoli\-db\db05.tsm,
Process Id 14.
ANR2240I Database volume F:\TIVOLI\DB\DB05.TSM defined.
ANR0986I Process 14 for DEFINE DBVOLUME running in the BACKGROUND
processed 1 items for a total of 1,049,624,576 bytes with a completion
state of SUCCESS at 04:57:47.
But so far when I type the Q DB command, the information about occupancy
is 93.2 %. What can I do to reduce this occupancy I haven´t experience in
DB Adm.
Thanks a lot...
Luciano
|
|
|