DB2 - Problem description
Problem IT24295 | Status: Closed |
RESTART OF A PARTITIONED DATABASE FAILS WITH SQL10003C ON NON-CATALOG PARTITION | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Problem description ===================== Customer re-initializes A snapshot backup of a multi-partitioned database in DPF running RESTART in parallel user a script which runs the command below on a non-catalog partition: $ db2_all "|| db2 restart db SAMP drop pending tablespaces (TEMP_DB, TEST_FLASH_0, TEST_FLASH_L) write resume SQL10003C There are not enough system resources to process the request. The request cannot be processed Occasionally this fails because one of the partitions is not able to resolve an in-doubt transaction. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 10 or higher * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.03.2018 19.07.2018 19.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |