We have requirement to load data in SQLServer 2008 Standard R2 database.
In addition we have to handle the Database fail over.
If Principle server is down, then jobs should load into the mirror server.
Do we have any option in Datastage/DSN to specify the Mirror sql server. ??
I haven't done failovers on SQL-Server, but doesn't the failover database inherit the database name and other attributes, making a failover almost transparent to the database users and not requiring multiple settings?
I'm not aware of a setting for this within DataStage itself, but the included DataDirect ODBC drivers may provide support for failover with SQL Server.
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
There's failover and then there's transparent failover. Which are you looking for? Disclaimer: I have no clue if SQL Server supports the latter, I just know the difference exists as I've had to deal with it in other environments in the past.
-craig
"You can never have too many knives" -- Logan Nine Fingers