[IQUG] [iqug] Quick verification

Mumy, Mark mark.mumy at sap.com
Thu Aug 2 09:24:37 MST 2018

No.  Tables get created on the default_dbspace.  If it wasn’t set then it was IQ_SYSTEM_MAIN.  You can check this with sp_iqdbspaceobjectinfo:

Lists objects and subobjects of type table (including columns, indexes, metadata, primary keys, unique constraints, foreign keys, and partitions) for a given dbspace. Not supported for RLV dbspaces.

You can also look at the systems tables to get this.  I am remote right now and don’t have my code that shows this…


Mark Mumy
Strategic Technology Incubation Group
SAP Global Center of Excellence |  SAP
M +1 347-820-2136 | E mark.mumy at sap.com<mailto:mark.mumy at sap.com>
My Blogs: https://blogs.sap.com/author/markmumy/

Conference tel: 18663127353,,8035340905#

From: "iqug-bounces at iqug.org" <iqug-bounces at iqug.org> on behalf of David Louie <David.Louie at blackrock.com>
Date: Thursday, August 2, 2018 at 11:10 AM
To: IQ Group <iqug at dssolutions.com>
Subject: [IQUG] [iqug] Quick verification

We deployed tables into our IQ server without setting the default_dbspace.  We not yet loaded any data and now just set the default_dbspace to our main dbspaces.

The data should flow to the default_dbspace without us having to drop and recreate the tables correct?


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.

© 2018 BlackRock, Inc. All rights reserved.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://iqug.org/pipermail/iqug/attachments/20180802/795abb7d/attachment.html>

More information about the IQUG mailing list