on 10-17-2006 1:21 AM
Hi,
How to see the database size of a particular instance in an AS400 ibm iseries server. Is there any commands for that.
Please let me know.
Thanks,
Sailesh K
Hi guys.... how can i get the following information from SAP GUI ?
Allocated DB space
Data size
Index size
Log size
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Christopher.
>
> Hi guys.... how can i get the following information from SAP GUI ?
>
> Allocated DB space
> Data size
> Index size
> Log size
Have you read the answers in this thread? They should answer the basic part of this question.
Beside that: Are you dealing with an SAP on IBM i installation? I'm asking as 'allocated DB space' and 'log size' are not the usual terms we use on this platform.
Best regards,
Jan Stallkamp
Hi,
on operating system you can use DSPLIB lib(R3<SID>DATA) output(*PRINT). Or DB02 in SAP.
regards thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you want to monitor this regularly by this library method, then you can set up via the GO DISKTASKS command from the operating system command line a report that can be run at predefined periods - weekly, monthly etc. See:
http://www-01.ibm.com/support/docview.wss?uid=nas116c246792830c6b186256a5b005dcec8
Hi Sailesh,
You could call Tcode DB02 and sum the total size of "tables", "primary keys", and "indexes". "Refresh file statistics" (in background) if the information might not be current.
Thank you,
Victor
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.