Filter
Top Products
42
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
The MIN_PASSWORD_LENGTH option is new in this version.
Function
Sets the minimum length for new passwords in the database.
Allowed values
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.
Scope
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.
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.
Column name Description