Product: Aqua Data Studio
Version: 16.0.0-dev-50
Build #: 41221
Build Date: 2014-Nov-25 04:25:39 PM
Operating Environment: Linux (2.6.32-431.20.3.el6.x86_64, amd64) / UTF-8 / en / US / Oracle Corporation 1.7.0_60-b19
Memory: Max=766,312,448; Total=218,382,336; Free=79,895,944; CPUs=1
Steps to reproduce :
1.Connect to Sybase ASE 16.0 database
2. Execute the below query from query analyzer window,
sp_dboption,'sample_db','dbo',false
Go
Database is set to offline mode.
Connect to DBA TOOLS--->Sybase ASE 16.0--->Storage Manager-->Database Tab.
Observation:
Here it is observed that status of the database "sample_db" is displayed as online instead of "offline".
Now click on Refresh icon,even after refresh database "sample_db" status is displayed as "online".
Scenario 2:
1.From DBA TOOLS--->Sybase ASE 16.0--->Storage Manager --->Database Tab.
2.Select database "sample_db" or any other database with status = online.,right click on it and select option-->Set Online.
Observation:
Here it is observed that when we will click on set online option for the database which is allready online,we get the below pop up message :
"Database is allready online"
When we click on Ok buton we get pop up message database is allready online.
In case of database Sql Server,when we follow the same steps mentioned in scenario 2 ,we get the below message
Database "aa123" set offline?
when we click on OK button ,database "aa123" is set to offline mode in case of Sql Server database
|
104 KB
|
113 KB
|
57 KB
The online, offline does not work the same for SQL Server and Sybase ASE. For SQL Server, there is an ALTER DATABASE [dbname] SET OFFLINE and ALTER DATABASE [dbname] SET ONLINE command.
For Sybase ASE, I tried the command you had given sp_dboption 'rendb_new','dbo',false
But once you do execute it and then use the query select name from master..sysdatabases where status2=16 I cannot find that the database is offline. Moving to 17 for the time being
Issue #12879 |
Closed |
Completion |
No due date |
No fixed build |
No time estimate |
The online, offline does not work the same for SQL Server and Sybase ASE. For SQL Server, there is an ALTER DATABASE [dbname] SET OFFLINE and ALTER DATABASE [dbname] SET ONLINE command.
For Sybase ASE, I tried the command you had given sp_dboption 'rendb_new','dbo',false
But once you do execute it and then use the query select name from master..sysdatabases where status2=16 I cannot find that the database is offline. Moving to 17 for the time being