on 04-23-2010 9:58 AM
HI all
Which transaction code is used to findout the spefic table size in tablespace, we are not able to findout the specific table size in transaction code DB02. Please help us.
1. How to archive the sap tablespace if you have any document to follow?
Regards
KRISH
Hello.
> HI all
>
> Which transaction code is used to findout the spefic table size in tablespace, we are not able to findout the specific table size in transaction code DB02. Please help us.
> 1. How to archive the sap tablespace if you have any document to follow?
Are you sure you are using IBM DB2 for i as the database? I'm wondering as you are talking about tablespaces which don't exist on this plattform
Best regards,
Jan Stallkamp
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
And if you are using DB2 for i, the command is:
DSPFD libraryname/filename - go to the bottom and it will tell you total records, total deleted records, and total of member sizes.
Just an FYI, after you archive, you will probably have a large number of deleted records so you will want to reorganize the file(s) to reclaim some of the space.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.