Troubleshooting
Problem
In a DB2 DPF/multipartition environment, you can use db2_all command to run commands or utilities across all database partitions or on specific partition(s). However if the commands or utilities to be run by db2_all may need user input via prompting, the db2_all command may appear to be hanging, never returns from the command line while waiting for user's input indefinitely.
Symptom
For example, if you are restoring a backup into an existing database on the partition 0 using below db2_all command:
db2_all "<<+0< db2 RESTORE DB v97eee FROM /db2backup "
SQL2539W Warning! Restoring to an existing database that is the same as the
backup image database. The database files will be deleted.
Do you want to continue ? (y/n) y
The restore command would prompt you with the warning SQL2539W to ask if you would like to continue to overwrite the existing database. However even though you enter "y" on the prompt, the command would never return, appear to be hanging.
Cause
This is because db2_all does not support user prompting.
Resolving The Problem
Before running the commands or utilities via db2_all, please make sure they don't prompt user for input during running. For db2 utilities, such as BACKUP/RESTORE, please specify WITHOUT PROMPTING and/or REPLACE EXISTING when it's applicable
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21685938