Posted by [IP Address: 198.106.235.44] 'EDM' on May 04, 2001 at 10:07:37 EST:
In Reply to: Compare Reports failure posted by [IP Address: 198.106.235.44] 'Maria' on May 03, 2001 at 12:51:30 EST:
Maria,
Make sure of the following:
1. Grant user authorities to both source and target database.
2. Grant source database authority to the target database.
3. Both database must reside in same AS/400 box.
4. Reports must be run on the server. An SPF file will be created
in the source database and the final output will be in
SQROUT.
5. You may also have to grant the user and database library
access to all object in PS library.
note: Grant authority to all objects in the target library.
: Hi everyone,
: We are trying to run Compare Report between
: development & test /test & production environments (DB2/400, HRMS 7.51).
: As soon as the SQR is started it bombs with message
: "SQR Error 1803 Disconnected. Probably wrong userid/password'
: The error log on the server says "No authority on PSLOCK".
: But the DB access we use normally wold have all privileges,
: including the one on PSLOCK. Does anybody know what it
: might be? Please help! Thanks a lot