× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
abhishekj(*) reported 2014-11-28T12:17:49Z  · tariqrahiman last modified 2014-11-28T20:05:35Z

Database status is displayed incorrect in storage manager and database is not set to offline mode for Sybase ASE 16.0


Dev
John LH
JohnLH
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component DBA-T - Sybase - Storage Mngr
Version Future - .9

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

 

 

 

3 attachments

Issue #12879

Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017