This below script should work in korn or posix shell. This script requires your password to be in a file, but you could also hardcode it or supply it as an argument. The user name, database name, grantee, and "grant" shown here are hardcoded, but they could also be arguments or...
I have encountered this same problem. I have a (posix) shell script that searches a given set of pools and finds all volumes with no unexpired savesets and then changes those volumes to recyclable. I will send this script to anyone who is interested.
Is there a command line command to change the retention date on a previously saved saveset? (I don't want to change the policy, only the retention date for one specific save set.)
You will probably need to use the Sybase supplied utilities "isql" or "bcp". They both require a user name and password. If you don't know these you might be lucky enough to have a system administrator account with a username of "sa" and a "null"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.