Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

DSNT501I -DBB DSNILMCL RESOURCE UNAVAILABLE

327 views
Skip to first unread message

Sergey Utkin

unread,
Apr 1, 2015, 7:45:18 AM4/1/15
to
Running some apps on WPS 7.0.0.5 (DB2 v9) we've got log like this below.
How can i determine the root cause and get rid of that kind of problems?
Need some step-by-step advices because im a newbie

DSNT375I -DBB PLAN=DSNRRSAF WITH 723
CORRELATION-ID=WBSR1AS
CONNECTION-ID=RRSAF
LUW-ID=RURZDGVC.DB2LU19.CE840A916097=80651
THREAD-INFO=WBDBU:*:*:*
IS DEADLOCKED WITH PLAN=?RRSAF WITH
CORRELATION-ID=WBSR1AS
CONNECTION-ID=RRSAF
LUW-ID=[***].DB2LU19.CE840A77A923=80634
THREAD-INFO=WBDBU:*:*:*
ON MEMBER DBB
DSNT501I -DBB DSNILMCL RESOURCE UNAVAILABLE 724
CORRELATION-ID=WBSR1AS
CONNECTION-ID=RRSAF
LUW-ID=[***].DB2LU19.CE840A916097=80651
REASON 00C90088
TYPE 00000304
NAME WBCELLDB.INST805 .X'000006' '.X'05'

found some info : log messages indicate that the job WBSR1AS deadlocked with another job WBSR1AS. So deadlocked job received "resource unavailable" error. CONNECTION-ID indicates that is a RRSAF job.
Cool, but still confused where can I find the rest of the info on WBSR1AS, RRSAF, TYPE 00000304 so i can recreate the whole picture?
0 new messages