Question & Answer
Question
How to find all the Cluster Based Tables (CBT) in a Netezza system?
Answer
You can run following SQL against individual user database to find CBTs in that database.
- SELECT a.*, b.*
FROM _t_organize_on a, _t_object b
WHERE a.ORGRELID = b.OBJID
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21699330