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
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
