Problem:

Customer wants to set up a central XDB Server for all users to use to connect to the DB2 location but they don't want to add all the userid's and passwords to this machine.How to do this.

Resolution:

The easy way is as follows:

Here's the easiest answer can think of:

1) Client side security on

2) Server side security off

3) User created, no password, password not required (as in the following)

CREATE USER MFIREC

    TYPE SUPERUSER

    PASSWORD "" REQUIRED NO;