[IQUG] [iqug] Clone IQ server question

Ron Watkins rwatkins at dssolutions.com
Wed Aug 23 15:50:34 MST 2017


The symlinks are extremely handy, especially if you anticipate either a MPX
config or using Snap/Clone luns for your storage.

Ron

 

From: Baker, Chris [mailto:c.baker at sap.com] 
Sent: Wednesday, August 23, 2017 3:23 PM
To: Louie, David
Cc: Ron Watkins; iqug at dssolutions.com
Subject: Re: [IQUG] [iqug] Clone IQ server question

 

Depending on how you set it up, you may want to create the first files in
the IQ_SYSTEM_MAIN and IQ_SYSTEM_TEMP small, as Ron says, but with a reserve
size to accommodate growth. 

 

That way you can decide to increase the size of the first dbfile without
having to drop anything, if you are setting up a simple IQ server, to keep
things flexible.

 

I would also suggest using symlinks in a standard directory structure
relative to the .db file and thereby allow relative path addressing to
simplify future device placement.

 

Chris

 

Chris Baker | Database Engineering Evangelist | CERT | PI HANA Platform Data
Management | SAP

T +1 416-226-7033 <tel:+1%20416-226-7033>  | M +1 647-224-2033
<tel:+1%20647-224-2033>  | TF +1 866-716-8860 <tel:+1%20866-716-8860> 

SAP Canada Inc. 445 Wes Graham Way, Waterloo, N2L 6R2
<x-apple-data-detectors://17/1> 

c.baker at sap.com | www.sap.com <http://www.sap.com/> 

 

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

Conference tel: 1-866-312-7353,,9648565377#
<tel:1-866-312-7353,,9648565377%23> 


On Aug 23, 2017, at 4:35 PM, Louie, David <David.Louie at blackrock.com> wrote:

Thanks Ron.   Was hoping this was the case (like ASE and the master
database)

Sent from my iPhone




On Aug 23, 2017, at 3:36 PM, Ron Watkins <rwatkins at dssolutions.com> wrote:

 

Yes, you do not need any USER datastore to build/configure an IQ node. Just
IQ_SYSTEM_MAIN and IQ_SYSTEM_TEMP.

I often build these with default filesystem store, which makes them tiny,
then add real MAIN/TEMP/USER stores and drop the original filesystem stores.

 

All you need is this as a minimum:

create database 'DBName'

      iq page size 65536      -- 65536 131072 262144 524288

      iq path 'main.iq'

      temporary path 'temp.iq';

 

-----Original Message-----

From: iqug-bounces at iqug.org [mailto:iqug-bounces at iqug.org] On Behalf Of
Louie, David

Sent: Wednesday, August 23, 2017 12:09 PM

To: 'iqug at dssolutions.com'

Subject: [IQUG] [iqug] Clone IQ server question

 

I'm building a gold copy IQ server which I can clone future builds.

 

At minimum I plan to have the IQ sysmain and IQ system temp and no main
dbspaces.

 

Can I still seed this GLD copy with set options, groups, and users without
creating the main dbspaces?

 

Thanks

David

 

 

This message may contain information that is confidential or privileged. If
you are not the intended recipient, please advise the sender immediately and
delete this message. See
http://www.blackrock.com/corporate/en-us/compliance/email-disclaimers for
further information.  Please refer to
http://www.blackrock.com/corporate/en-us/compliance/privacy-policy for more
information about BlackRock's Privacy Policy.

For a list of BlackRock's office addresses worldwide, see
http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.

 

(c) 2017 BlackRock, Inc. All rights reserved.

 



For a list of BlackRock's office addresses worldwide, see
http://www.blackrock.com/corporate/en-us/about-us/contacts-locations.

C 2017 BlackRock, Inc. All rights reserved.
_______________________________________________
IQUG mailing list
IQUG at iqug.org
http://iqug.org/mailman/listinfo/iqug

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20170823/8f73c70b/attachment-0001.html>


More information about the IQUG mailing list