Step 2: Add the Ingres CICS User
By default, CICS/6000 applications access Ingres databases using the effective Ingres user name “cics” (unless the 'options =-uusername' flag is specified in the XA open string).
To add the “cics” user to the Ingres installation
1. Invoke the SQL Terminal Monitor at the operating system prompt, and connect to the iidbdb:
isql iidbdb
2. Issue the following create user statement:
create user cics
with privileges = (createdb,security,operator);
For more information on the create user statement, see the SQL Reference Guide.