RE: CPF32A6 - Cross-reference notification 1061 for request 2, problem type 1.

Rob,

Opened a PMR.
Have been told previously by IBM not to run RCLSTG unless instructed.
Yes, I remember the long running RCLSTG.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Tuesday, September 06, 2016 9:05 AM
To: Midrange Systems Technical Discussion
Subject: Re: CPF32A6 - Cross-reference notification 1061 for request 2, problem type 1.

There's two items of concern here:
- Fixing the problem
- Trying to figure out what caused the problem to reduce the possibility of it recurring.

As far as fixing the problem you need to run either RCLSTG SELECT(*DBXREF) or RCLSTG SELECT(*ALL)

The first (*DBXREF) I don't recall seeing it take more than 20 minutes.
Across more than a dozen lpars.
The latter I've seen WIDELY vary depending on the individual lpar on the same machine. And reduce drastically if that lpar was unloaded/reloaded from a Power 6 to a Power 8. I've seen times vary from 11 hours to a few minutes.

As far as determining what caused it will require you open a ticket with IBM.

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: "Steinmetz, Paul" <PSteinmetz@xxxxxxxxxx>
To: "'Midrange Systems Technical Discussion'"
<midrange-l@xxxxxxxxxxxx>
Date: 09/06/2016 08:34 AM
Subject: CPF32A6 - Cross-reference notification 1061 for request 2,
problem type 1.
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



On my R&D LPAR, I received this message the last three times I was
deleting library D1BRFILES.

From the message, I see a reference to object PYRRTV01.

The object was deleted fine with no issues seen in the joblog.

D1BRFILES/PYRRTV01 is a X-LIB LF.
I have other X-LIB LF, so I don't think that should be the reason.

Any thoughts on what might be causing this issue.


Message . . . . : CPF32A6 Cross-reference notification 1061 for request
2, problem type 1.

Cause . . . . . : A problem was detected while processing the system
cross-reference files. The problem type is 1.
The problem types and their meanings follow:
0 -- Context recovery
1 -- Inconsistent data was discovered in the cross-reference files for

library D1BRFILES. The system may not allow operations to objects in
library
D1BRFILES. The SQL catalogs may not be up to date. The system may not
allow
constraints to be added or removed. The system may not allow triggers
to be
added or removed.
2 -- An unexpected condition was encountered
3 -- Exit condition
Recovery . . . : If the problem type is 1, request a reclaim storage

(RCLSTG command specifying SELECT(*ALL) or SELECT(*DBXREF) )
Technical description . . . . . . . . : Additional information:
- Problem Type : 1
- Request : 2
- Instance : 1061
- IASP/ASP Number : 0
- Failing Context : D1BRFILES
- Object Context : D1BRFILES
- Object Name : PYRRTV01
- Cross-reference Context: QSYS
- Cross-reference File : QADBXREF
- Record Attribute : PF
- Record Claim : X'A8A28983819340868993854040404040'
- Request Claim : X'00000000000000000000404040404040'
- Reference Count : 0
- Second Context : *NONE
- Second Name : *NONE
- Alternate Name : *NONE
- Second Alternate Name : *HEXTOSYM
*DEVD
QSWMSGRPY *INFO *
- Attribute Library : *NONE
- Attribute Name : *NONE
- Request Job Name : BRMBRCD1D
- Request Job User : ICAPICTL
- Request Job Number : 071399
- Request Job Thread ID : X'00000000000002D0'

Thank You
_____
Paul Steinmetz
IBM i Systems Administrator

Pencor Services, Inc.
462 Delaware Ave
Palmerton Pa 18071

610-826-9117 work
610-826-9188 fax
610-349-0913 cell
610-377-6012 home

psteinmetz@xxxxxxxxxx
http://www.pencor.com/