How to check table size in db2 sap?

Question Posted / suman kumar

1 Answers
1124 Views
I also Faced
E-Mail Answers

How to check table size in db2 sap?..

Answer / Sanjeet Kumar Choudhary

To check the size of a DB2 table in SAP, use the following SQL command:n```sqlnSELECT TABLESPACE_NAME, TABLESPACE_SIZE, TABSCHEMA, TABNAME, TABLE_SZ FROM SYSIBM.SYSTABLESTATS WHERE TABSCHEMA = 'your_schema' AND TABNAME = 'your_table';n'"` Replace `your_schema` and `your_table` with the appropriate values.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More DB2 Interview Questions

Can I use LOCK TABLE on a view?

1 Answers

I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?

10 Answers Fidelity,

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers CTS, IBM,

Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam

1 Answers Mphasis,

What is coalesce in db2?

1 Answers

What else is there in the PLAN apart from the access path?

1 Answers

How do I import a csv file into db2?

1 Answers

where will u check for sqlcode ?

2 Answers TCS,

What is the function of buffer manager?

1 Answers

How to get the ddl of a table in db2?