Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Troubleshooting Tips for SYDB Agent
DB Agent Tips
Trouble Shooting Tips
Arc-Serve 200 Backup Agent for Sybase Adaptive Server
1)Sybase Backup Agent Setup
a)Ensure the agent is installed using a Sybase login with SA privileges.
b)The Backup Agent allows the user to customize the product by modifying settings in the Windows NT/2000 Registry. There are settings that can be set by using the Windows NT/2000 REGEDT32 or REGEDIT utility. Backup Agent settings are listed in the HKEY_LOCAL_MACHINE window under the following key:
i)If Sybase Adaptive Server Agent is installed
(1)SOFTWARE\ComputerAssociates\ARCserveIT\DSAgent\CurrentVersion\agent\dbsyb
(2)Several optional settings are provided for the Backup Agent under the dbsyb key:
(3)Change the Debug to detail trace
(a)Set debug:REG_DWORD:1 to enable debug trace for the Backup Agent.
(b)Set debug:REG_DWORD:2 to enable detail debug trace for the Backup Agent.
(c)Enable this setting will write a detailed log to dbasyb.trc located in the dbasyb directory created during the install of the CA Sybase DB agent.
(4)Remember to restart the backup agent RPC service the make the changes effective.
2)Other troubleshooting tools available
a)There is also some hints in the dbasyb.log file located in the same directory as the dbasyb.trc file.
b)You can also look into the Sybase backup log usually named ôMachinename_bs.logö located in x:\Sybase\install directory
c)You can always call CA support but you already know more than they do with the above information. LOL
3)** NOTE** after running restore the database will be in an offline state and will need to be brought up to an online state.
4)Example of how to use the log:
5)While attempting to run a restore
i)The first attempt failed due to login problems
ii)Second attempt failed due to pipe time out error.
(1)E8602 Failed to read from database. (DBNAME=sandbox transaction, EC=Backup Agent Error - (83) "Remote pipe open failed: time-out".)
iii)After reading the dbasyb.trc file the error was that the backup SA user must have exclusive use of database to run load.
iv)Knowing this information I discovered that my DBA had an open connection to the file I was trying to restore. After I kicked my DBA out of the file with his tools the restore was successful.
Robert L. Gawne
Network Administrator
Camelback Research Alliance
************************************************************
If this FAQ helped you please rate it
Any questions email me with the link provided.
Arc-Serve 200 Backup Agent for Sybase Adaptive Server
1)Sybase Backup Agent Setup
a)Ensure the agent is installed using a Sybase login with SA privileges.
b)The Backup Agent allows the user to customize the product by modifying settings in the Windows NT/2000 Registry. There are settings that can be set by using the Windows NT/2000 REGEDT32 or REGEDIT utility. Backup Agent settings are listed in the HKEY_LOCAL_MACHINE window under the following key:
i)If Sybase Adaptive Server Agent is installed
(1)SOFTWARE\ComputerAssociates\ARCserveIT\DSAgent\CurrentVersion\agent\dbsyb
(2)Several optional settings are provided for the Backup Agent under the dbsyb key:
(3)Change the Debug to detail trace
(a)Set debug:REG_DWORD:1 to enable debug trace for the Backup Agent.
(b)Set debug:REG_DWORD:2 to enable detail debug trace for the Backup Agent.
(c)Enable this setting will write a detailed log to dbasyb.trc located in the dbasyb directory created during the install of the CA Sybase DB agent.
(4)Remember to restart the backup agent RPC service the make the changes effective.
2)Other troubleshooting tools available
a)There is also some hints in the dbasyb.log file located in the same directory as the dbasyb.trc file.
b)You can also look into the Sybase backup log usually named ôMachinename_bs.logö located in x:\Sybase\install directory
c)You can always call CA support but you already know more than they do with the above information. LOL
3)** NOTE** after running restore the database will be in an offline state and will need to be brought up to an online state.
4)Example of how to use the log:
5)While attempting to run a restore
i)The first attempt failed due to login problems
ii)Second attempt failed due to pipe time out error.
(1)E8602 Failed to read from database. (DBNAME=sandbox transaction, EC=Backup Agent Error - (83) "Remote pipe open failed: time-out".)
iii)After reading the dbasyb.trc file the error was that the backup SA user must have exclusive use of database to run load.
iv)Knowing this information I discovered that my DBA had an open connection to the file I was trying to restore. After I kicked my DBA out of the file with his tools the restore was successful.
Robert L. Gawne
Network Administrator
Camelback Research Alliance
************************************************************
If this FAQ helped you please rate it
Any questions email me with the link provided.