-
Title
Unable to browse DB2 tablespace - error code SQL0332N. -
Description
Unable to browse DB2 tablespace - error code SQL0332N.
Symptoms:
Unable to browse DB2 tablespace with pop-up message - Failed to connect to database . SQLState=57017. SQLCode=-332. [IBM][CLI Driver]SQL0332N There is no available conversion for the source code page "xxx" to the target code page "xxx". Reason code "1", SQLSTATE=57017
Running backup with DB2 instance or database selected fails with error -Failed to get Tablespaces for database
Failed to add tablespace index to Db
-
Resolution
Make sure that the LANG variable for DB2 user is same as that of NetVault. When different, stop NetVault service on the NetVault client, set the same LANG variable and then restart NetVault service.
The simplest solution is to check/edit the profile of the DB2 user and root.
Add the lines (Bourne shell example) -
LANG= (note, where xxxx is the LANG variable for the db2 user)
export LANG
When logged in as root of the DBS user, use the command "echo $LANG" to make sure the variable is correct. No DB2 service restart is required. -
Additional Information
Date - 12/2007
Affected Product & Version - NetVault: Backup 7.4.5 and later
Affected Module & Version - APM for DB2
OS Version - All supported OS
Application Information - DB2 8.1/8.2 (32/64bit)