home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC76851 Status: Geschlossen

OUTPUT ROWS ARE NOT ALIGNING PROPERLY FOR SELECT QUERY IF COLUMN IS GRAPHIC
ON V95FP6

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
Output rows are not aligning properly for select query if column 
is graphic on v95fp6 
 
Create a table having some graphic datatype columns 
on v95fp6 project, linuxamd64 platform and s100918 build. Post 
insert command, the rows fetched is bit misaligned and hence 
creating confusion. 
 
Steps to repro: 
db2 create db migdb using codeset UTF-8 territory US 
connect to migdb user newton using ****** 
create table tbgraphic (c1 graphic not null, c2 graphic with 
default,c3 graphic with default gx'0041') 
create table tcgraphic2 as (select * from tbgraphic) definition 
only 
commit 
 
Issues: 
create table tbgraphic (c1 graphic not null, c2 graphic with 
default,c3 graphic with default gx'0041') 
select * from tbgraphic 
C1 C2 C3 
-- -- -- 
G   A        << Here 'A' belongs to C3 but it is not properly 
aligned 
123456       --- We see it is on 5th position. I am expecting 
'A' at 7th position. 
  1 record(s) selected. 
 
select * from tcgraphic2 
C1 C2 C3 
-- -- -- 
G -  - 
123456        -- Here the value '-' value is at 6th position 
  1 record(s) selected.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Output rows are not aligning properly for select query if    * 
* column                                                       * 
* is graphic on v95fp6                                         * 
*                                                              * 
*                                                              * 
*                                                              * 
* Create a table having some graphic datatype columns          * 
* on v95fp6 project, linuxamd64 platform and s100918 build.    * 
* Post                                                         * 
* insert command, the rows fetched is bit misaligned and hence * 
*                                                              * 
* creating confusion.                                          * 
*                                                              * 
*                                                              * 
*                                                              * 
* Steps to repro:                                              * 
*                                                              * 
* db2 create db migdb using codeset UTF-8 territory US         * 
*                                                              * 
* connect to migdb user newton using ******                    * 
*                                                              * 
* create table tbgraphic (c1 graphic not null, c2 graphic with * 
*                                                              * 
* default,c3 graphic with default gx'0041')                    * 
*                                                              * 
* create table tcgraphic2 as (select * from tbgraphic)         * 
* definition                                                   * 
* only                                                         * 
*                                                              * 
* commit                                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* Issues:                                                      * 
*                                                              * 
* create table tbgraphic (c1 graphic not null, c2 graphic with * 
*                                                              * 
* default,c3 graphic with default gx'0041')                    * 
*                                                              * 
* select * from tbgraphic                                      * 
*                                                              * 
* C1 C2 C3                                                     * 
*                                                              * 
* -- -- --                                                     * 
*                                                              * 
* G  A        << Here 'A' belongs to C3 but it is not properly * 
*                                                              * 
* aligned                                                      * 
*                                                              * 
* 123456      --- We see it is on 5th position. I am expecting * 
*                                                              * 
* 'A' at 7th position.                                         * 
*                                                              * 
*   1 record(s) selected.                                      * 
*                                                              * 
*                                                              * 
*                                                              * 
* select * from tcgraphic2                                     * 
*                                                              * 
* C1 C2 C3                                                     * 
*                                                              * 
* -- -- --                                                     * 
*                                                              * 
* G -  -                                                       * 
*                                                              * 
* 123456        -- Here the value '-' value is at 6th position * 
*                                                              * 
*   1 record(s) selected.                                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to db2_v95fp9 or later releases.                     * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
db2_v95fp9 and later releases contains the fix. After the fix, 
indentation issue will be solved.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.06.2011
12.03.2012
12.03.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
9.5.0.9 FixList