Re: V5R3 - CPYTOIMPF fails with Error 3029

Tom, I already do that. But when I retry the
cpytoimpf after a 30 sec delay, I am getting "prepare
statement in use" error.......

Anyway, I have requested the admin not to back up this
particular directory and also have moved this
cpytoimpf in to a new program with an activation group
of *new. let me see how this goes, if it doesn't
work, then probably, I will be directly writing to IFS
file thru rpg.

Thanks for your reply though.

Siva.

--- Tom Liotta <qsrvbas@xxxxxxxxxxxx> wrote:

Sivaramakrishnan S wrote:

The To file is created using the CPYTOIMPF command

and

so there should be no locks even before the file

is

created. I understand that the Resource Busy is

the

error description for 3029, but not sure what

resource

is busy.

When I retry the cpytoimpf command after 30 sec

delay,

its giving "prepare statement in use"

error....there

is no sql in this pgm...may be internally it uses

some

sql to cpy stuff....

Siva:

I can only add a guess that it is not the file that
is in-use but
rather a directory in the path.

If this is happening during IFS backups, the
directory/path might be
temporarily unavailable. Perhaps the program simply
needs to monitor
for this error, execute a delay for a minute, and
loop back to try
again.

Tom Liotta

--
Tom Liotta
The PowerTech Group, Inc.
19426 68th Avenue South
Kent, WA 98032
Phone 253-872-7788 x313
253-479-1416
Fax 253-872-7904
http://www.powertech.com

--
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,
visit:

http://lists.midrange.com/mailman/listinfo/midrange-l

or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the
archives
at http://archive.midrange.com/midrange-l.

____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping