[IQUG] [iqug] Quick verification
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…
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?
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...
More information about the IQUG