Database Upgrades

The second step in the migration process is migrating to the most recent versions of the Adaptive Server Enterprise and Sybase IQ databases.

RAP 4.1 used Adaptive Server Enterprise 15.5 and Sybase IQ 15.2. RAP 5.0 uses Adaptive Server Enterprise 15.7 and Sybase IQ 15.4. See the Adaptive Server Enterprise and Sybase IQ migration guides for detailed upgrade procedures.

The schema for the RAPStore table, RAP_WORK_FILE, has also changed. To update this table, run the following SQL:

alter table RAP_USER.RAP_WORK_FILE   
DROP TRAN_ID,   
DROP OP_DB_IP,   
DROP OP_DB_PORT,   
DROP OP_DB_USER,   
DROP OP_DB_PASS,   
ADD ADAPTER_NAME SYB_VERYLARGESTRING NOT NULL;    
commit;

The Sybase IQ Output adapter also requires permissions to allow for client-side loading of files. The following commands will enable client side loading on the database, and grant permissions to perform client-side loading to the RAP_USER:

set option public.allow_read_client_file='on';   
grant READCLIENTFILE to RAP_USER;

Aside from the change to the RAP_WORK_FILE table and the permissions on the Sybase IQ database, there are no additional changes to the Adaptive Server and Sybase IQ schema.