Re: System i Navigator error when accessing Schemas

[Evan Harris <auctionitis@xxxxxxxxx>]

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.