> I am attempting to take an SAP DB 7.4 (on W2K) database > offline and online (or perform a shutdown and startup on it) > with an EXEC SQL call from another program through ODBC. I > have been successful in connecting to it as DBA but get -3005 > sqlerrors when sending "SHUTDOWN", "SHUTDOWN IMMEDIATE" or > "OFFLINE" as EXEC SQL statements. I don't see any such > Manager-level commands in the SQL Syntax List (SAP DB > Reference). Is there something basic I'm missing? Thanks > for responding.
SAP DB uses an architecture where each database instance uses it's own process. Therefor, it has to be managed from outside of the database. See http://sapdb.2scale.net/moin.cgi/DbmAutomation for information on how to do this programatically. To be exact, it is possible to send a SHUTDOWN when using the right client library, but it simply isn't possible to restart from a SQL connection because the connection can't be created when the database isn't running. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
