Sybase Comprehensive Guide to Page Size and IQ Configuration

Column name	Description
Nblocks	Number of IQ blocks
Info	Component of the IQ index for which the Kbytes, Pages,
	and Compressed Pages are being reported. The
	components vary by index type. For example, the default
	(FP) index includes BARRAY and Bitmap (BM)
	components. The Low_Fast (LF) index includes Btree
	(BT) and Bitmap (BM) components.

9.5.6 SP_IQSTATUS now displays IQ Page Size

The sp_iqstatus stored procedure now displays the IQ page size in addition to the block size. For example, Adaptive Server IQ used to display:

Block Size: 512/2bpc

It now displays:

Page Size: 1024/512blksz/2bpc

9.5.7 MIN_PASSWORD_LENGTH option

Function Allowed values

Scope

The MIN_PASSWORD_LENGTH option is new in this version.

Sets the minimum length for new passwords in the database.

Integer, greater than or equal to zero.

The value is in bytes. For single-byte character sets, this is the same as the number of characters.

Can be set for the PUBLIC group. Takes effect immediately. DBA permissions are required to set this option.

Default	0 characters
Description	This option allows the database administrator to impose a minimum length on
	all new passwords for greater security. Existing passwords are not affected.
Example	• Set the minimum length for new passwords to 6 bytes.
	SET OPTION PUBLIC.MIN_PASSWORD_LENGTH = 6

9.5.8 Transaction Log utility

The following information on the Transaction Log utility should be added to the Adaptive Server IQ Administration and Performance Guide and the Adaptive Server IQ Reference.

42