when you do a wrkobjlck on a *file, be sure to use
the MBR(*ALL) keyword...
On 7/17/2014 8:39 AM, Hoteltravelfundotcom wrote:
according to the message i see now that there is a logical on the PF in
question, in fact there are 15 people with locks on this! thank you kindly
for your help.
OS is 5770SS1 V7R1M0 5050 IBM i
Release of base option . . . . . . . : V7R1M0 L00
TL13037 Temporarily applied
CPF3203 Diagnostic 40 07/17/14 08:44:24.029714 QDBTRIG2
QSYS *STMT QDBTRIGG QSYS
From module . . . . . . . . :
From procedure . . . . . . :
Statement . . . . . . . . . : 1604
Message . . . . : Cannot allocate
object for file TRNSTATPF in ASTCCDTA.
Cause . . . . . : The requested
operation was not performed for member *N
file TRNSTATPF in library ISTDTA,
because member *N file TRNSTAT1 in
library ISTDTA type *FILE was not
available. Recovery . . . : Ensure
the object is not locked in another
process or in another thread within this
process. Also, ensure the object, or
a logical file based on the object, is
not open in this process. Try the
request again when the object is
On Thu, Jul 17, 2014 at 9:28 AM, Buck Calabro<kc2hiz@xxxxxxxxx> wrote:
On 7/17/2014 8:50 AM, Hoteltravelfundotcom wrote:
I get this message: but the object has no lock on it.
I have security officer User level. What else can it be? i am able to add
triggers in other libraries on this file.
ADDPFTRG FILE(ISTDTA/TRNSTATPF) TRGTIME(*AFTER) TRGEVENT(*UPDATE)
Trigger operation not successful.
> From program . . . . . . . . . : QDBTRIGG
From library . . . . . . . . : QSYS
Instruction . . . . . . . . : 0370
Is this intended to be a general discussion of the myriad ways ADDPFTRG
can be 'not successful'? The reason I ask is that there are very few
details with which the list can work. This will result in time
consuming back and forth messages as individual list members ask for
clarification on one point or another.
Please help us to help you. With every question, please include:
1) The operating system version and Technology Refresh level. This is
important because different capabilities are available with more recent
operating system versions. DSPPTF and WRKPTFGRP will find these.
2) The full first and second level message text. This reveals the error
message ID (in this case, CPF32C6) as well as any reason codes and
recovery operations (in this case, 'See the error messages previously
3) The full first and second level text of the previous messages in the
job log. The architecture of IBM i is that a given process will issue
informational and diagnostic messages before failing with an escape
message. Those diagnostics are the actual reason the process failed.
4) The command that caused the failure (supplied here, thank you). This
is important because seeing the exact parameters can reveal the root
cause. Often, the simplest way to provide all of this information is to
DSPJOBLOG OUTPUT(*PRINT) and copy/paste the result in the initial question.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives