SYMBOLGEN: Macro variable DMDATASRC resolves to acpme
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
ERROR: CLI error trying to establish connection: [IBM][CLI Driver] SQL30082N Security processing failed with reason "24"
("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001
The DB2 connection works fine in all jobs with the same user. SELECT rights are granted.
It seems the statement does not use the correct credentials. The DB2 lib is preassigned.
There could be an issue with the connection to the metadata server that metalib uses from its own sas session. Couple of things to try:
1. Make sure the SCHEMA name matches exactly the schema in the database including the appropriate case in the preassigned library
2. Turn off the "enable optional metadata macros" in DI Studio tools/options/code generation.
3. Open a code editor window and attempt the same call to metalib and make sure it works from your session.
I did check with the developer, and there is some thought that there hasnt been any code changes in the user name resolution since 9.1.3SP4 so this problem has been there for a while. There is a TS track logged on the issue, and we will investigate a fix for a future release.