turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Search instead for
Did you mean:
Mark as New
Subscribe to RSS Feed
Get Direct Link
Email to a Friend
Report Inappropriate Content
I have done
showfsp -d 15
This gives me report for no of cylinders which could free up when packed to desired FSP of 15%. Now the showfsp report has the following columns
databasename | tablename | fsp% | recoverable cylinders | current cylinder
Now the question is there is specific ration between recoverable cylinders and current cylinder which tells me that we should run packdisk
i.e sum(recoverable cylinders)/sum(current cylinder) if greater than XX.XX value then run packdisk.
Please let know in case of any clarifications.
Thanks in advance
All forum topics
© 2017 Teradata. All rights reserved.