CPF5257

[Inquirer]

Can anyone help me about this:
Server AS/400.
Single processor.
V5.1
DB2/400.
I have physical file with over 10 000 000 records and
size over 3,5 GB. There is only about 5000 deleted records.
I use about 30 logical files for reading this data in some sort and/or
select.
After two years of everyday use I started to receive error CPF5257.
First on one file and after I deleted it and created it again, error
happened on other one.

Does anyone know reason for that.
Please respond.
Inquirer.

[leszek]

Re: CPF5257

[color=blue]
> Server AS/400.
> Single processor.
> V5.1
> DB2/400.
> I have physical file with over 10 000 000 records and
> size over 3,5 GB. There is only about 5000 deleted records.
> I use about 30 logical files for reading this data in some sort[/color]
and/or[color=blue]
> select.
> After two years of everyday use I started to receive error CPF5257.
> First on one file and after I deleted it and created it again, error
> happened on other one.
>[/color]
Look on this message:

Message ID . . . . . . . . . : CPF5257
Message file . . . . . . . . : QCPFMSG
Library . . . . . . . . . : QSYS

Message . . . . : Failure for device or member &4 file &2 in library
&3.
Cause . . . . . : An error occurred during a read or write
operation. If
this is a display file, the display may not be usable.
Recovery . . . : See the previously listed messages, correct the
errors,
and try the request again. If the problem continues, report the
problem
(ANZPRB command).

Check WRKPRB or ANZPRB, look in joblog.
I think it may be hardware problem.

Regards
Leszek G.

[Kim Kuras]

Re: CPF5257

"Inquirer" <slobodnjak@net .hr> wrote in message news:<bsonv4$st s$1@sunce.iskon .hr>...[color=blue]
> Can anyone help me about this:
> Server AS/400.
> Single processor.
> V5.1
> DB2/400.
> I have physical file with over 10 000 000 records and
> size over 3,5 GB. There is only about 5000 deleted records.
> I use about 30 logical files for reading this data in some sort and/or
> select.
> After two years of everyday use I started to receive error CPF5257.
> First on one file and after I deleted it and created it again, error
> happened on other one.
>
> Does anyone know reason for that.
> Please respond.
> Inquirer.[/color]

Were there any messages previous to the CPF5257?

[Inquirer]

Re: CPF5257


"Kim Kuras" <kim_kuras@dart container.com> wrote in message
news:b67543bf.0 312290744.79915 656@posting.goo gle.com...[color=blue]
> "Inquirer" <slobodnjak@net .hr> wrote in message[/color]
news:<bsonv4$st s$1@sunce.iskon .hr>...[color=blue][color=green]
> > Can anyone help me about this:
> > Server AS/400.
> > Single processor.
> > V5.1
> > DB2/400.
> > I have physical file with over 10 000 000 records and
> > size over 3,5 GB. There is only about 5000 deleted records.
> > I use about 30 logical files for reading this data in some sort and/or
> > select.
> > After two years of everyday use I started to receive error CPF5257.
> > First on one file and after I deleted it and created it again, error
> > happened on other one.
> >
> > Does anyone know reason for that.
> > Please respond.
> > Inquirer.[/color]
>
> Were there any messages previous to the CPF5257?[/color]

Didn't find any
..

[Steve Landess]

Re: CPF5257

[color=blue]
> "Inquirer" <> wrote:
> Can anyone help me about this:
> Server AS/400.
> Single processor.
> V5.1
> DB2/400.
> I have physical file with over 10 000 000 records and
> size over 3,5 GB. There is only about 5000 deleted records.
> I use about 30 logical files for reading this data in some sort and/or
> select.
> After two years of everyday use I started to receive error CPF5257.
> First on one file and after I deleted it and created it again, error
> happened on other one.[/color]

Can you post the *exact* text of the CPF5257 message from the job log of the
job where the error occurred? This would be helpful in diagnosing your
problem.

Also, specify what Cumulative PTF level that your system is on. It is very
possible that you need a PTF to fix this problem.

I did a search on Google for CPF5257 and found several entries for this
message id. A couple of them indicated that there might be a PTF needed.

Steve Landess
Austin, Texas
(512) 423-0935

[Inquirer]

Re: CPF5257


"Steve Landess" <steve_landess@ hotmail.com> wrote in message
news:A35Ib.9656 $DC4.6542@fe2.t exas.rr.com...[color=blue]
>[color=green]
> > "Inquirer" <> wrote:
> > Can anyone help me about this:
> > Server AS/400.
> > Single processor.
> > V5.1
> > DB2/400.
> > I have physical file with over 10 000 000 records and
> > size over 3,5 GB. There is only about 5000 deleted records.
> > I use about 30 logical files for reading this data in some sort and/or
> > select.
> > After two years of everyday use I started to receive error CPF5257.
> > First on one file and after I deleted it and created it again, error
> > happened on other one.[/color]
>
> Can you post the *exact* text of the CPF5257 message from the job log of[/color]
the[color=blue]
> job where the error occurred? This would be helpful in diagnosing your
> problem.
>
> Also, specify what Cumulative PTF level that your system is on. It is[/color]
very[color=blue]
> possible that you need a PTF to fix this problem.
>
> I did a search on Google for CPF5257 and found several entries for this
> message id. A couple of them indicated that there might be a PTF needed.
>[/color]

Display Spooled File
File . . . . . : QSYSPRT
Page/Line 1/6
Control . . . . .
Columns 1 - 130
Find . . . . . .

*...+....1....+ ....2....+....3 ....+....4....+ ....5....+....6 ....+....7....+ .
....8....+....9 ....+....0....+ ....1....+....2 ....+....3
Print Key Output Page
1
5722SS1 V5R1M0 010525 S65xxxxx 27/12/03
08:17:36
Display Device . . . . . : DSPxxx
User . . . . . . . . . . : xxxxxx
Additional Message Information
Message ID . . . . . . : RPG1299
Date sent . . . . . . : 27/12/03 Time sent . . . . . . :
07:44:58
Message . . . . : CPF5257 I/O error was detected in Lxxxxxx (C G S D F).
Cause . . . . . : The RPG program Pxxxx in library xxx received the
message
CPF5257 at statement 18000 while doing SETLL I/O operation on file
Lxxxxxx.
Actual file is xxxDB/Lxxxxxx MEMBER - Lxxxxxx. See the job log for a
complete description of message CPF5257.
Recovery . . . : Enter C to cancel, G to continue processing at *GETIN,
S
to obtain a printout of system storage, D to obtain an RPG formatted
printout of system storage, or F to obtain a full formatted printout of
system storage.
Possible choices for replying to message . . . . . . . . . . . . . . . :

Release V5R1M0
Last PTF TL02134 (Package C2134510)

[Dan Hicks]

Re: CPF5257

Maybe you should post the text of the 5257 message.

Inquirer wrote:
[color=blue]
>
>
> Display Spooled File
> File . . . . . : QSYSPRT
> Page/Line 1/6
> Control . . . . .
> Columns 1 - 130
> Find . . . . . .
>
> *...+....1....+ ....2....+....3 ....+....4....+ ....5....+....6 ....+....7....+ .
> ...8....+....9. ...+....0....+. ...1....+....2. ...+....3
> Print Key Output Page
> 1
> 5722SS1 V5R1M0 010525 S65xxxxx 27/12/03
> 08:17:36
> Display Device . . . . . : DSPxxx
> User . . . . . . . . . . : xxxxxx
> Additional Message Information
> Message ID . . . . . . : RPG1299
> Date sent . . . . . . : 27/12/03 Time sent . . . . . . :
> 07:44:58
> Message . . . . : CPF5257 I/O error was detected in Lxxxxxx (C G S D F).
> Cause . . . . . : The RPG program Pxxxx in library xxx received the
> message
> CPF5257 at statement 18000 while doing SETLL I/O operation on file
> Lxxxxxx.
> Actual file is xxxDB/Lxxxxxx MEMBER - Lxxxxxx. See the job log for a
> complete description of message CPF5257.
> Recovery . . . : Enter C to cancel, G to continue processing at *GETIN,
> S
> to obtain a printout of system storage, D to obtain an RPG formatted
> printout of system storage, or F to obtain a full formatted printout of
> system storage.
> Possible choices for replying to message . . . . . . . . . . . . . . . :
>
> Release V5R1M0
> Last PTF TL02134 (Package C2134510)
>
>[/color]



--
Dan Hicks
Peace, like charity, begins at home. --Franklin D Roosevelt

[Steve Landess]

Re: CPF5257

It looks like you're behind on PTF's...I have TL03007 on my system (9406-170
running V5R1). I would download and install the latest cumulative PTF's
before proceeding any further...

Steve


"Inquirer" <> wrote in message news:bsr97n$k81 $1@sunce.iskon. hr...[color=blue]
>
> "Steve Landess" <steve_landess@ hotmail.com> wrote in message
> news:A35Ib.9656 $DC4.6542@fe2.t exas.rr.com...[color=green]
> >[color=darkred]
> > > "Inquirer" <> wrote:
> > > Can anyone help me about this:
> > > Server AS/400.
> > > Single processor.
> > > V5.1
> > > DB2/400.
> > > I have physical file with over 10 000 000 records and
> > > size over 3,5 GB. There is only about 5000 deleted records.
> > > I use about 30 logical files for reading this data in some sort and/or
> > > select.
> > > After two years of everyday use I started to receive error CPF5257.
> > > First on one file and after I deleted it and created it again, error
> > > happened on other one.[/color]
> >
> > Can you post the *exact* text of the CPF5257 message from the job log of[/color]
> the[color=green]
> > job where the error occurred? This would be helpful in diagnosing your
> > problem.
> >
> > Also, specify what Cumulative PTF level that your system is on. It is[/color]
> very[color=green]
> > possible that you need a PTF to fix this problem.
> >
> > I did a search on Google for CPF5257 and found several entries for this
> > message id. A couple of them indicated that there might be a PTF[/color][/color]
needed.[color=blue][color=green]
> >[/color]
>
> Display Spooled[/color]
File[color=blue]
> File . . . . . : QSYSPRT
> Page/Line 1/6
> Control . . . . .
> Columns 1 - 130
> Find . . . . . .
>
>[/color]
*...+....1....+ ....2....+....3 ....+....4....+ ....5....+....6 ....+....7....+ .[color=blue]
> ...8....+....9. ...+....0....+. ...1....+....2. ...+....3
> Print Key Output[/color]
Page[color=blue]
> 1
> 5722SS1 V5R1M0 010525 S65xxxxx 27/12/03
> 08:17:36
> Display Device . . . . . : DSPxxx
> User . . . . . . . . . . : xxxxxx
> Additional Message Information
> Message ID . . . . . . : RPG1299
> Date sent . . . . . . : 27/12/03 Time sent . . . . . . :
> 07:44:58
> Message . . . . : CPF5257 I/O error was detected in Lxxxxxx (C G S D[/color]
F).[color=blue]
> Cause . . . . . : The RPG program Pxxxx in library xxx received the
> message
> CPF5257 at statement 18000 while doing SETLL I/O operation on file
> Lxxxxxx.
> Actual file is xxxDB/Lxxxxxx MEMBER - Lxxxxxx. See the job log for a
> complete description of message CPF5257.
> Recovery . . . : Enter C to cancel, G to continue processing at[/color]
*GETIN,[color=blue]
> S
> to obtain a printout of system storage, D to obtain an RPG formatted
> printout of system storage, or F to obtain a full formatted printout[/color]
of[color=blue]
> system storage.
> Possible choices for replying to message . . . . . . . . . . . . . . . :
>
> Release V5R1M0
> Last PTF TL02134 (Package C2134510)
>
>[/color]

[JG1X0000]

Re: CPF5257

I agree.

"Steve Landess" <steve_landess@ hotmail.com> wrote in message
news:ILpIb.1217 1$xU1.5196@fe1. texas.rr.com...[color=blue]
> It looks like you're behind on PTF's...I have TL03007 on my system[/color]
(9406-170[color=blue]
> running V5R1). I would download and install the latest cumulative PTF's
> before proceeding any further...[/color]

[leszek]

Re: CPF5257

> It looks like you're behind on PTF's...I have TL03007 on my system
(9406-170[color=blue]
> running V5R1). I would download and install the latest cumulative[/color]
PTF's[color=blue]
> before proceeding any further...
>
> Steve[/color]

Inquirer wrote:[color=blue][color=green]
>>..
>>After two years of everyday use I started to receive error CPF5257.
>>First on one file and after I deleted it and created it again, error
>>..[/color][/color]

I don't understud.
He write that about two years everything was OK, but
now was wrong.
Any changes in hardware or software?

Why You tell that He must install lates cumulative patch.
(it may help or not)
I don't find any FIX for this error on IBM site.

Regards
Leszek G.

[Inquirer]

Re: CPF5257


"leszek" <dlkgruszczynsc ynospam_12@pocz ta.onet.pl> wrote in message
news:bsu3gj$8gc $1@news.onet.pl ...[color=blue]
>
> Inquirer wrote:[color=green][color=darkred]
> >>..
> >>After two years of everyday use I started to receive error CPF5257.
> >>First on one file and after I deleted it and created it again, error
> >>..[/color][/color]
>
> I don't understud.
> He write that about two years everything was OK, but
> now was wrong.
> Any changes in hardware or software?
>[/color]

Well, a few months ago I used RGZPFM on several physical files
including this one which LF failed.

[Dan Hicks]

Re: CPF5257

Inquirer wrote:[color=blue]
> "leszek" <dlkgruszczynsc ynospam_12@pocz ta.onet.pl> wrote in
> message news:bsu3gj$8gc $1@news.onet.pl ...
>[color=green]
>> Inquirer wrote:
>>[color=darkred]
>>>> .. After two years of everyday use I started to receive
>>>> error CPF5257. First on one file and after I deleted it and
>>>> created it again, error ..
>>>[/color]
>> I don't understud. He write that about two years everything was
>> OK, but now was wrong. Any changes in hardware or software?
>>[/color]
>
>
> Well, a few months ago I used RGZPFM on several physical files
> including this one which LF failed.[/color]

Once again, what is the text of the CPF5257? I don't have a
reference handy, but it seems like that would be the place to start.


--
Dan Hicks
If the opposite of pro is con, what's the opposite of congress?