[IQUG] [iqug] Clone IQ server question

Baker, Chris c.baker at sap.com
Wed Aug 23 15:23:05 MST 2017


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<mailto: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<mailto: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<mailto: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> [mailto:iqug-bounces at iqug.org] On Behalf Of Louie, David
Sent: Wednesday, August 23, 2017 12:09 PM
To: 'iqug at dssolutions.com<mailto: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<mailto: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/d12572db/attachment.html>


More information about the IQUG mailing list