iqheader Database Administration Utility

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 IQ server.

The user interface is a standalone console application called iqheader (header.exe on Windows). The iqheader tool searches the device for an IQ dbspace header and reports the header information in a user-readable format.

Note: LUN is a logical unit number and is used to identify SCSI devices so the host can address and access the data on each disk drive in an array.

Syntax

iqheader [ [ dbspace_path ] 

Parameters

The iqheader application takes a single parameter, which is the device to be checked.

Usage

iqheader output

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 IQ block, in bytes

Page Size

Size of IQ page, in bytes

First Block

First IQ block number mapped to dbspace

Block Count

Number of IQ blocks that map to actual disk blocks

Reserve Blocks

Number of IQ blocks that may be added to this dbspace

Last Real Block

Last IQ block number that maps to an actual disk block

Last Mapped Block

Last IQ 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)

Example

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