APAR status
Closed as fixed if next.
Error description
After successful column analysis, customer is having problems with the Data Class she "selects" during column analysis review being kept by the system. The values selected are systematically replaced by other types - see attached documentation. It appears that if you accept the systems recommendation of an indentifier type during the review, the type will default to a "Large Object". If you change a TEXT/Indicator/Indentifier column to CODE as your "selected" data type, the system will default the CODE to a TEXT. Everything looks fine during the initial review, with the system accepting the changes, accepting the "review" checkbox and saving the changes. Once you get out of the initial review process, the values are changed to the defaults as described above. Even if you go back in and change the values once more, or re-do the review, in the end the values are defaulted as described above. This has been tried on multiple columns in multiple tables in several databases.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: 81 users trying to set values in CA **************************************************************** PROBLEM DESCRIPTION: After successful column analysis, customer is having problems with the Data Class she "selects" during column analysis review being kept by the system. The values selected are systematically replaced by other types -see attached documentation. It appears that if you accept the systems recommendation of an indentifier type during the review,the type will default to a "Large Object". If you change Indentifier column to CODE as your "selected" data type, the system will default the CODE to TEXT. Everything looks fine during the initial review, with the systemaccepting the changes, accepting the "review" checkbox and saving the changes. Once you get out of the initial review process, the values are changed to the defaults as described above. Even if you go back in and change the values once more, or re-do the review, in the end the values are defaulted as described above. This has been tried on multiple columns in multiple tables in several databases. **************************************************************** RECOMMENDATION: Affected customers should upgrade to 8.1 RP2. This change is also included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
JR31692
Reported component name
WIS INFORM ANAL
Reported component ID
5724Q36IA
Reported release
801
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-01-16
Closed date
2009-03-17
Last modified date
2009-12-18
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CA
Fix information
Applicable component levels
R801 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.0.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
18 December 2009