Personal tools
You are here: Home → DB2 → Problem Resolution → Locking errors → Lock Internal Plan X
Navigation
Log in


Forgot your password?
 
Document Actions

Lock Internal Plan X

Deadlocks and Lock timeout are caused by LOCKs Internal Plan (X)

Check if there are invalid packages on database: 

select PKGSCHEMA from syscat.packages where valid<>'Y'

If invalid packages were found, apply db2rbind command to fix the problem:


db2rbind <dbname> -l <logfile>
Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls