Unable to run Information Analyzer column analysis

Oritech · Post by **Oritech** » Fri Aug 07, 2009 1:24 am

Trying to run an Information Analyzer column analysis for the first time and getting the following message in the log after it fails :

An error occurred while accessing the ScratchSpace[ibm][db2][jcc][t4][2010][11248] Connection authorization failure occurred. Reason: Password expired

Also searching on forum gives some clue that DB2 password migh have expired,which user id it may be & where to check it ? though not sure....

Wondering on it...

tcj · Post by **tcj** » Sun Aug 09, 2009 8:18 pm

Have you set up the Analysis Engine and Analysis Database settings under HOME>Anaylsis settings?

vmcburney · Post by **vmcburney** » Sun Aug 09, 2009 9:24 pm

There is the DataStage credentials user, the DB2 login in the IADB database repository and the DB2 login for the XMETA repository. Check them all for synchronised passwords in DB2 and on the operating system.