Re: [IQUG] QUESTION: how do I list all Sybase IQ Server databases?

[Mumy, Mark]

Databases are only visible on the network if the IQ server/instance was set up to broadcast.  Unlike ASE and SQL Server, a “database” in IQ is tied to a server and isolated from all other databases.  While you can start an IQ instance with multiple databases, they are isolated from each other and consequently you cannot “use” a database or see a database.

To see which databases are started, you would need to make sure that the server broadcast is enabled (it is by default, so make sure that the DOBROADCAST is set to ON and the –sb option is not set to set to 1).  So long as broadcast is enabled you can then see all servers and databases on your network.  The “on your network” will vary depending on topology.  We use UDP broadcasting to see servers.  Standard UDP broadcast rules would apply.  For instance, the UDP default is that it cannot be routed across subnets.

To list the databases, per server, you can use the dblocate command with the –d option.

Here I have 1 IQ instance running but dblocate shows 2 databases (IQDB and iqdemo):

sybase@sap-m6600:~/IQDB$ ps -eaf|grep iqsrv | grep -v grep

sybase   10161     1  2 09:15 ?        00:00:03 /home/sybase/IQ16sp8/IQ-16_0/bin64/iqsrv16 @params.cfg -n IQSERVER IQDB.db iqdemo.db -gn 25 -hn 5

sybase@sap-m6600:~/IQDB$ dblocate -d

SQL Anywhere Server Enumeration Utility Version 16.0.0.808

Server Name           Address         Database(s)

-----------           -------         -----------

iqserver              sap-m6600:2638  IQDB,iqdemo

1 server found

Mark

 

Mark Mumy

Director, Enterprise Architecture, Global HANA CoE |  SAP

M +1 347-820-2136 | E mark...@sap.com

My Blogs: http://scn.sap.com/people/markmumy/blog

 

https://sap.na.pgiconnect.com/I825063

Conference tel: 18663127353,,7090196396#

From: "iqug-b...@iqug.org" on behalf of Tomas Dalebjork
Date: Monday, June 15, 2015 at 18:16
To: Chris Baker, "iq...@iqug.org", IQ Group, "iq...@googlegroups.com"
Subject: Re: [IQUG] QUESTION: how do I list all Sybase IQ Server databases?

Thanks

It was one of our customers who has two different databases.
But our solution to protect them can't list all databases as we thought it was not possible to have more than one per IQ Server instance.

Thanks Chris

"Baker, Chris" <c.b...@sap.com> skrev: (15 juni 2015 23:02:09 CEST)

It is not generally suggested to run more than one database in an IQ instance.

 

Regardless, the databases are separate and distinct, so they have no knowledge of each other within a server, so an SP is not possible.

 

If the server is broadcasting, you can use ‘dblocate -d’ utility to list the databases within a server.

 

Chris

 

Chris Baker | Platform Architect | D&T Global CoE | SAP
T +1 416-226-7033 | M +1 647-224-2033 | TF +1 866-716-8860

SAP Canada Inc. 4120 Yonge Street, Suite 600, Toronto, M2P 2B8

c.b...@sap.com | www.sap.com

 

https://sap.na.pgiconnect.com/I826572

Conference tel: 1-866-312-7353,,9648565377#

 

From: iqug-b...@iqug.org [mailto:iqug-b...@iqug.org] On Behalf Of Tomas Dalebjork
Sent: Monday, June 15, 2015 4:52 PM
To: iq...@iqug.org; iq...@dssolutions.com; iq...@googlegroups.com
Subject: [IQUG] QUESTION: how do I list all Sybase IQ Server databases?

 

Hi,

I have just created one new database named "COMPANY", the other is the "IQDEMO"

The question I have is, how do I list all the databases existing for one Sybase IQ Server instance?

Like "sp_helpdb" in Sybase ASE?

regards Tomas

 

Tomas Dalebjörk | CIO
+46 (0)31 322 4359
REPOSTOR AB
Första Långgatan 19, 41327 Göteborg, Sweden

Follow us at
Twitter | http://twitter.com/#repostor-ab

[Mark Mumy]

Supported, yes, but not recommended.  The biggest issue I have is the cfg file.  See, the cfg file applies to EACH database being started.  that means that to start 2 databases in a single server, each database would have the same configuration (memory, threads, etc).  If you have one database per server, you can change the cfg file to match each databases workload.

Also, with 1 server and multiple databases, if the server crashes or needs to be restarted for any reason then all databases have to come offline.  

Mark

On Jun 16, 2015, at 09:30, Tomas Dalebjork <tomas.d...@repostor.com> wrote:

Thanks Mark,

So it is supported to have more than one database on one instance?

But not recommended by SAP to have more than one database per instance?

Regards Tomas

_______________________________________________
IQUG mailing list
IQ...@iqug.org
http://iqug.org/mailman/listinfo/iqug