Re: Issues adding tables to journaling though System i Navigator

[CRPence <CRPbottle@xxxxxxxxx>]

  There were many more apparently problematic messages issued before 
the SQL0901 was listed.  Most notably a MCH1210 was the first message 
preceding many instances of "File not found" where the replacement text 
values are very suspect.  FWiW a copy\paste from an interactive request 
to DSPJOBLOG OUTPUT(*) lacks significant relevant /context/ for the 
situation [including the V#R#M# which appears in the headings].  A 
DSPJOBLOG OUTPUT(*PRINT) for a job defined with LOG(4 0 *SECLVL) 
provides the context that is missing from the non-spooled version.

  FWiW the SQL0901 to SQL is the effective equivalent of CPF9999 to the 
OS; i.e. they are both a /generic/ "function check" condition to explain 
a prior unmonitored\unhandled error condition.  It is always the prior 
condition(s) that lead to the generic failure that are relevant; 
although whether the relevant details are available in prior messaging, 
is not assured.

  In this case however, at least the CPF4204 is shown in the joblog... 
but its details and context are missing.  As well as all of the other 
messages preceding that /generic/ query failure... which, like the other 
aforementioned /generic/ failures, *preceding* conditions and thus 
possibly preceding *messages* are also likely relevant details to 
further describe the problem.  But again, the /context/ for the errors 
is important, and only the *spooled* joblog [with LOG(4 0 *SECLVL) 
provides that information, both concisely and in its entirety.

Regards, Chuck

On 06 May 2013 06:46, Mike Wills wrote:
> When I list tables (the plus sign on the left side to get a list of
> tables) to add a table to journaling though the Start/End Journaling
> dialog box I get the following error:
>
> SQL0901 SQL system error.
>
> <<SNIP>>
>
> Looking at the job log, I see:
>
> =========
> Job 065563/QUSER/QZDASOINIT started on 05/06/13 at 06:58:38 in subsystem
>    QUSRWRK in QSYS. Job entered system on 05/06/13 at 06:58:38.
> User XXXXXXXXX from client 192.168.XXX.XXX connected to server.
> The following special registers have been set: CLIENT_APPLNAME: CWBUNNAV
> Receiver value too small to hold result.
> File   HVR0005F in library ORMAT0001 not found.
> File  in library  not found.
> <<SNIP three identical to above>>
> File V in library  not found.
> File  in library  not found.
> <<SNIP fifteen identical to above>>
> Internal failure occurred in query processor.
> SQL system error.
> Ownership of object GPTFLST in QTEMP type *USRSPC changed.
> Output file QAUGDBJOBN created in library QTEMP.
> Member QAUGDBJOBN added to output file QAUGDBJOBN in library QTEMP.
> =========
>
> This happens on multiple computers.