The iqheader utility is a dbspace header utility that determines which server, if any, is using a particular device, file, or LUN (Logical Unit Number) as a dbspace to analyze disk usage or to configure a multiplex query server.
The iqheader utility reports the configuration of an arbitrary device regardless of whether it is currently in use by an SAP Sybase IQ server.
The user interface is a standalone console application called iqheader (header.exe on Windows). The iqheader tool searches the device for an SAP Sybase IQ dbspace header and reports the header information in a user-readable format.
>iqheader Usage: iqheader [dbspace_path]
>iqheader /dev/null Not an IQ file: Error 0
>iqheader /dev/rdsk/c1t32d0s1 < Open Failed: No such file or directory >iqheader /dev/rdsk/c1t3d0s1 < Open Failed: Permission denied
Field |
Description |
---|---|
File Name |
Name of the file. |
Full Path |
Full path after symbolic link resolution |
Version |
Dbspace file format version |
File ID |
Unique number assigned to each dbspace |
Create Time |
Time of dbspace creation |
RW Mode |
Current read-write mode: RW, RO, RW, N/A (Upgraded) |
Last RW Mode |
Last dbspace mode |
Size (MB) |
DBSpace size, in megabytes |
Reserve (MB) |
DBSpace reserve size, in megabytes |
Block Size |
Size of block, in bytes |
Page Size |
Size of page, in bytes |
First Block |
First block number mapped to dbspace |
Block Count |
Number of blocks that map to actual disk blocks |
Reserve Blocks |
Number of blocks that may be added to this dbspace |
Last Real Block |
Last block number that maps to an actual disk block |
Last Mapped Block |
Last block number mapped to dbspace |
OFlag |
Online status (YES/NO) |
Create ID |
Commit ID in which dbspace was created |
Alter ID |
Last commit ID in which dbspace was altered |
DBID1 |
Location of first database identity |
DBID2 |
Location of second database identity |
DBSpace ID |
Unique identifier assigned to each dbspace |
_NextFLAllocLowerBank |
Lower bound of pre-allocate space for dbspace |
_NextFLAllocUpperBank |
Upper bound of pre-allocate space for dbspace |
Pre-alter commit ID |
Commit_id in the system tables ISYSDBFILE and ISYSIQDBSPACE |
_ReqNumFreeListBlocks |
Number of blocks of type 'F' (free list blocks) |
This example shows output for iqheader:
File Name: file1.iq Full Path: /dev/dsk/file1.iq DBFile Header Info Version: 2 File ID: 16395 Create Time: 2008-06-02 21:57:00 RW Mode: RO Last RW Mode: RW Size (MB): 20 Reserve (MB): 20 Block Size: 8192 Page Size: 131072 First Block: 9408960 Block Count: 2560 Reserve Blocks: 2560 Last Real Block: 9411519 Last Mapped Block: 10454399 OFlags: 1 Create ID: 6905 Alter ID: 6964 DBID1: 0 DBID2: 0 DBSpace ID: 16395 _NextFLAllocLowerBank: 0 _NextFLAllocUpperBank: 0 Pre-alter commit ID: 6925 Dropped: NO