cancel
Showing results for 
Search instead for 
Did you mean: 

How to archive the table entries

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

JanStallkamp
Employee
Employee
0 Kudos

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

Former Member
0 Kudos

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.