No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>

Reminder

To have a better experience, please upgrade your IE browser.

upgrade

FAQ- How to check size of tables of Sybase database to dump it

Publication Date:  2012-07-25 Views:  34 Downloads:  0
Issue Description
Q:
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

Alarm Information
Null.

Handling Process
A:
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

use DB
go

truncate table tbl_tablename
go



Root Cause
Null.

Suggestions
Null.

END