Problem:

Setting up SQL Option users who only need security only when connecting to DB2 locations

Resolution:

Many customers connect to XDB Server locations and also connect to mainframe DB2 locations using SQL Option.  Since a password is required to connect to a DB2 location, client security must be turned on.  However, that does not mean that a password needs to be required for connecting to XDB Server locations.  The following will outline the steps needed to set up XDB access for these situations so a password is not needed to gain access.

1)     Turn client side security on by going to Options - SQL for DB2 - Options - Security and ensure Client Security is enabled.

2)     Turn server side security off by going to Options - SQL for DB2 - Server.  

a.      If running the blue screen server, select F3 - SQL Engine Options and F1 - XDB Server Security.

b.      If running the service server, select the General tab and ensure Server Security is not checked.

3)    Either add the userid to the XDB Server with the following sql:

CREATE USER MFIREC

         TYPE SUPERUSER

         PASSWORD "" REQUIRED NO;

Or by selecting Admin - Users from SQLWizard as shown in the attached screen shot.

Attachments:

xdbsecurity.jpg