|
Problem IC72769
|
Status: Geschlossen |
EXPORT MAY INCORRECTLY REPORT SQL27981W, IF THERE IS A 4-CHARACTER TOKEN IN THE EXPORT'S SELECT STATEMENT |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
DB2 export command may incorrectly report a SQL27981W warning
message.
For example, any of the following will generate the SQL27981W
warning message:
db2 "export to abc.del of del values ('ABC ')"
db2 "export to abc.del of del values ('ABC ' || ' ')"
db2 "export to abc.del of del select tabname, 'ABC ' from
syscat.tables"
db2 "export to test.ixf of ixf select case when name='AAAA' then
'11' else '22' end from sysibm.systables"
Example output:
$ db2 "export to abc.del of del select tabname, 'ABC ' from
syscat.tables"
SQL3104N The Export utility is beginning to export data to file
"abc.del".
SQL27981W The utility could not verify presence of attached or
detached data
partitions in the target table or the source table.
SQL3105N The Export utility has finished exporting "360" rows.
Number of rows exported: 360
Explanation: DB2 scans and parses the select statement of an
export command, and incorrectly determines that the first
4-character token (from token 3 onwards) it finds as the FROM
keyword, and the next token as the table name. It then runs
some internal SQL queries using the table name to determine
table characteristics. If it does not determine the correct
FROM keyword (for example, a 4-character token precedes the real
FROM keyword), then the internal SQL queries with the wrong
table name may fail with syntax errors, and DB2 export will then
return the SQL27891W warning message. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Users of export who are including literal values *
****************************************************************
* PROBLEM DESCRIPTION: *
* See above. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.5 Fix Pack 8 or a later release that *
* includes the fix. *
**************************************************************** |
| Local-Fix: |
The incorrect SQL27981W warning message can be ignored, or user
can attempt to modify the export's select statement slightly so
that it does not contain 4-character tokens preceding a valid
FROM keyword, and still have the correct semantic meaning.
For example, the following will not generate the warning:
db2 "export to abc.del of del values ('ABC')"
db2 "export to abc.del of del values ('ABC' || ' ')"
db2 "export to abc.del of del values (cast ('ABC ' as char
(4)))"
db2 "export to abc.del of del select tabname, cast ('ABC ' as
char (4)) from syscat.tables"
db2 "export to test.ixf of ixf select case when DEPTNAME = 'AAA'
then '11' else '22' end from org" |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
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 |
Problem was first fixed in Version 9.5 Fix Pack 8. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC72964 IC72965
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 23.11.2010
08.07.2011
08.07.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP8
|
| Problem behoben lt. FixList in der Version |
| 9.5.0.8
|
 |
