MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » March 2014

Re: Problem creating a view



fixed

That's perfectly normal. If the group isn't perm applied, etc it shows
you both the current level & the previous level. Doing WRKPTFGRP
PTFGRPLVL(*LATEST) will show you only the current PTF level for the
groups.


Thanks,
Tommy Holden



From: "Mark Murphy/STAR BASE Consulting Inc." <mmurphy@xxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 03/12/2014 01:35 PM
Subject: Re: Problem creating a view
Sent by: midrange-l-bounces@xxxxxxxxxxxx



No and No.

More info: We are on 7.1 TR6, but Work with PTF Groups shows some
duplication that leads me to believe that something might be wrong.
Particularly the DB2 group is on there twice, once at level 21, and once
with level 23.

SF99710 12279 Installed <--- CUMULATIVE PTF PACKAGE
C2279710
SF99710 13037 Installed <--- CUMULATIVE PTF PACKAGE
C3037710
SF99709 77 Installed <--- GROUP HIPER
SF99709 85 Installed <--- GROUP HIPER
SF99708 26 Installed GROUP SECURITY
SF99707 5 Installed <--- TECHNOLOGY REFRESH
SF99707 6 Installed <--- TECHNOLOGY REFRESH
SF99705 4 Installed HARDWARE AND RELATED PTFS
SF99701 21 Installed <--- DB2 FOR IBM I
SF99701 23 Installed <--- DB2 FOR IBM I
SF99637 7 Installed DB2 WEB QUERY FOR IBM I
V1.1.2
SF99627 8 Installed 7.1 ELECTRONIC SERVICES GROUP
PTF
SF99572 12 Installed JAVA

Is this normal?

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Mark S Waterbury <mark.s.waterbury@xxxxxxxxxxxxx> wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: Mark S Waterbury <mark.s.waterbury@xxxxxxxxxxxxx>
Date: 03/12/2014 01:54PM
Subject: Re: Problem creating a view

Mark:

Is there a QDFTJRN *DTAARA in this library where you are trying to
create this view?

Is this customer running a "high availability" or "disaster recovery"
product that might now require journaling of all tables (physical files)?

Hope that helps,

Mark S. Waterbury

On 3/12/2014 1:39 PM, Mark Murphy/STAR BASE Consulting Inc. wrote:
Let's get this out of the way first, V7.1 TR

I am having trouble creating a specific view. The error is CPF6968
Journal entry cannot be associated with file WBOODV100.

I can execute the select statement by itself, but when I add create or
replace view to the front of it, I get the error.

Here is the sql:

create or replace view wboodv100
as
with openorders as (
select current_date as asofdate
, left(dcstkl,3) as dcplnt
, dcobal
from ocrh
where dcstat <> 'C')
select asofdate, dcplnt, sum(dcobal) as dcobal
from openorders
group by asofdate, dcplnt;

Now I have seen this error before with other views, and if I drop the
view before running the create, the error goes away, and I am able to
create the view successfully. The difference here is that the view does
not exist. It is normally a intermittent problem that I can get around.
This time I can't seem to find the magic formula. I can and have created
other views in the same library. This happens within Squirrel, System i
Navigator, and on Green Screen SQL.

Squirrel reports:
Error: [SQL0901] SQL system error.
SQLState: 58004
ErrorCode: -901.
I believe it is the same error.

Can anyone shed some light on this for me?

One more thing. There is no journal in BKNTEST, and the tables
referenced in the view are not journaled. This has not been a problem
before, or at least not one that stopped me from creating views.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx






Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact