DB2 - Problem description
Problem IT27632 | Status: Closed |
ISSUING SET_PASSTHRU INSIDE A CLP SCRIPT CAN LEAD TO A CRASH IF THE FEDERATED DATA SOURCE RETURNS AN ERROR. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
A CLP Script that contains a SET_PASSTHRU statement may crash if an error is returned from the Federated Data Source. An example would be similar to: connect to sample ; set passthru fed_server_1 ; select col1, col2 from table_1 ; select col3, col4 from table_2 ; connect reset; | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All Federated users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 FP12 * **************************************************************** | |
Local Fix: | |
Execute the SET_PASSTHRU statement outside of the CLP Script. | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 28.12.2018 25.02.2020 25.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |