suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

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)