User ran a SQL collection and got an error: SQL Analysis agent (Dispatcher) generated a software exception. Reason code: 0x6
SQLLIB directory was incorrect
Check the environment and configuration files in the $QUESTHOME/<host name>/env and $QUESTHOME/<host name>/config directory for the instance where the managed database resides.
1. Edit the ScAgent-<instance_name>.env file, correct the LD_LIBRARY_PATH and LIBPATH for the SQLLIB directory, make the change, and restart the agent
2. Check the variables using the SET command and DB2SET and make sure no issues with the SQLLIB directory.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center