Types of Database Space in Sybase IQ

Share this article :
DBspace TypeDescriptionFiles Contained by DBspace Number of DBspace
SYSTEM System tables / views / stored procedures / SQL Anywhere tables and function definitions1>1
Other catalog dbspaces SQL Anywhere tables1>1
IQ_SYSTEM_MAIN IQ database structures including IQ rollforward / rollback data for each committed transaction and each active checkpointed transaction / the incremental backup metadata and database space and identity metadata. IQ user objects may be stored here but Sybase recommends that you put them in other main dbspaces>1>1
Other main dbspaces (also called user dbspaces) IQ objects such as tables / indexes / join indexes and table metadata>1>1
IQ_SYSTEM_TEMP Set of 1 to n temporary dbfiles that define a single temporary dbspace for a standalone database or multiplex node>11
IQ_SYSTEM_MSG External file that logs messages about database activity1 per multiplex node1

Related posts

How to Create Technical User in SAP IQ Cockpit
How to Drop Connection in Sybase IQ
How to Change A User Password in Sybase IQ
How to Add New Data File into Existing DBspace (Sybase IQ)
© 2018 ITsiti. All Rights Reserved
Powered by KEEM