Customer is asking how to check which tables have large size at IPMS DB and how to dump them through DB commands?
Database: Sybase 15.0
Kindly check attached script and example of result, each table has 4 records, large tables has large values, after locating them, need to check with R&D if these tables have important data or not, then use below commands to dump it.
To use the script, kijndly run below command from shell:
#isql -SN2000DBServer -Usa -P$dbpwd -iscript_name
After checking result file, run below commands from DB
truncate table tbl_tablename