Re: System i Navigator error when accessing Schemas

Hi Rob

Why would you run a RCLSTG after a full restore ? What's the logic to
support that, or is "just because" ?

I do plenty of migrations like this and there is no need to run a RCLSTG.

Note also that it isn't included in any of the IBM steps on "Recovering
your system" or "recovering your system to a different server".


On Fri, Oct 9, 2015 at 4:22 AM, <rob@xxxxxxxxx> wrote:

I know that some feel that a RCLSTG is an archaic tool which should never
be run anymore but I disagree and believe that after such a restore is an
excellent time to run it. Did you?

The image did not come through.

Can you post the actual error message id from the joblog? I suspect that
querying by that sqlstate will not be fruitful.

I have a few 7.1 lpars left.
DSPOBJD OBJ(QDBSSUDF2) OBJTYPE(*srvPGM) DETAIL(*SERVICE)
Licensed program . . . . . . . . . . : 5770SS1 V7R1M0
PTF number . . . . . . . . . . . . . : SI57581




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: Mike Cunningham <mike.cunningham@xxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 10/08/2015 11:10 AM
Subject: System i Navigator error when accessing Schemas
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



We are migrating from a power 6 to a power 8 system and did a full system
save on the old system and a full restore on the new system. Same level of
i OS on both (7.1) and same patch level on both. On the old system we can
access the Schemas section under Databases without error but on the new
system we get this error.


[cid:image001.png@01D101B7.8AB892D0]

We get a similar error when trying to use the Database Maintenance tool in
Navigator but that error window lets us see the joblog which is showing
this additional detail

Cause . . . . . : An error occurred while invoking user-defined function
OBJECT_STATISTICS in library QSYS2. The error occurred while invoking the
associated external program or service program QDBSSUDF2 in library QSYS,
program entry point or external name QSQOBSTAT, specific name QSQOBSTAT.
The error occurred on member QAUGDBNAV file QAUGDBNAV in library QUSRSYS.
The error code is 1. The error codes and their meanings follow:
1 -- The external program or service program returned SQLSTATE
ŸŸ000. The text message returned from the program is:



Has anyone ever seen this before?


Mike Cunningham
VP of Information Technology Services/CIO
Pennsylvania College of Technology


--
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.




--
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.