System Administration Guide: Volume 1 Documentation Changes

Read about updates to the Sybase IQ System Administration Guide.

System Administration Guide: Volume 1 updates
CR# Description
671393
  • CommBufferSize Connection Parameter [CBSize] – In Connection and Communication Parameters > Connection Parameters > CommBufferSize Connection Parameter [CBSize], the minimum value of CommBufferSize should be 500, not 300.

    The example should be:

    To set the buffer size to 500 bytes:
    ...
CommBufferSize=500
...
642412
  • Troubleshooting Recovery – If you cannot start a server or database in a multiplex, forced recovery may be needed. Use forced recovery only when normal database recovery fails to restore the database to a running state, and only if you see s_buf or free list errors during recovery. Never use forced recovery in response to SA errors, such as SA transaction log replay failure.
  • If you have followed documented recovery procedures and Sybase Technical Support recommends forced recovery, follow these steps: –
    1. Shut down all secondary nodes using stop_iq.
    2. Start the server with the -iqfrec and -iqmpx_sn 1 flags:
      start_iq -n my_server -x 'tcpip(port=7934}' 
-gd dba -gm 1 -iqmpx_sn 1 -iqfrec 
my_db /database/my_db.db
    3. Connect to the server and run:
      sp_iqcheckdb 'dropleaks database'
checkpoint
    4. Correct errors and rerun sp_iqcheckdb. Repeat until no errors result.
    5. Shut down and restart the server normally (without the flags in Step 2).
Parent topic: Documentation Changes