System is recovered

[sysprog]

DB2/CICS/QMF is recovered.
Please let us know if there is any other issues.

[drbob1]

Shortly before midnight Saturday, Feb 18, I started having the same problem as reported by raghuk87 on Thursday, Feb 16 in the thread "Logon Error". I get the following message several times as ISPF tries to start:

ICH408I USER(DRBOB1 ) GROUP(USERG02 ) NAME(ROBERT WOODSIDE )
CATALOG.Z16.MASTER CL(DATASET ) VOL(Z6SYS1)
INSUFFICIENT ACCESS AUTHORITY
FROM CATALOG.**.MASTER (G)
***

Then, once ISPF is up, I find that none of my files (HLQ = 'DRBOB1') can be found.

Interestingly, I can go into OMVS and my Unix directory structure and files seem intact.

I was on the system several times during the day and evening on Thursday and Friday, and everything was fine. I've no idea when things went sour on Saturday, because I wasn't on till a little before midnight.

I've no idea whether this is some collateral damage from the recent major system corruption, but clearly

• I'm not unique in experiencing this problem; and
• it isn't a one-time occurrence (raghuk87 reported the problem as happening on Thursday, mine happened this evening).

Any idea what's happening?

Cheers,
Bob

[prino]

Bob,

Your datasets are still on the system (and in CATALOG.USERS8.UCAT), but the ALIAS entry is gone, which makes them inaccessible. I may have authority to create an alias, but as I do not know where and how to get the correct links from master to user catalog, you'd better send a PM to sysprog and ask him to create one.

Robert

[rsilver]

DB2/CICS/QMF is recovered.
Please let us know if there is any other issues.

Hi Sysprog,

Found an issue with QMF PF2=List, getting this message

Column LABEL of view Q.DSQEC_TABS_LDB2L is too long.

Column LABEL of view Q.DSQEC_TABS_LDB2L is
too long.

Explanation:
You requested information that causes QMF to select from the view named
in global variable DSQEC_TABS_LDB2. That view,
Q.DSQEC_TABS_LDB2L, contains a column named
LABEL, which is too long. The column is defined with a
length of 90, but the maximum allowed length is 30. The column
must be defined with a length of 30 or less before the view can be
used to get the information you requested.

Code: Select all

Column Name               Column Type Column Length
------------------------- ----------- -------------
OWNER                     VARCHAR     128           
TNAME                     VARCHAR     128           
TYPE                      VARCHAR     5             
SUBTYPE                   CHAR        1             
MODEL                     VARCHAR     1             
RESTRICTED                VARCHAR     1             
REMARKS                   VARCHAR     254           
CREATED                   VARCHAR     1             
MODIFIED                  VARCHAR     1             
LAST_USED                 VARCHAR     1             
LABEL                     VARCHAR     90           
LOCATION                  CHAR        16           
OWNER_AT_LOCATION         VARCHAR     128           
NAME_AT_LOCATION          VARCHAR     128           


[sysprog]

The datasets DRBOB1.** has been recovered.

[rsilver]

The datasets DRBOB1.** has been recovered.

It is still not fixed

Column LABEL of view Q.DSQEC_TABS_LDB2L is |
too long. |
|
Explanation: |
You requested information that causes QMF to select from the view named |
in global variable DSQEC_TABS_LDB2. That view, |
Q.DSQEC_TABS_LDB2L, contains a column named |
LABEL, which is too long. The column is defined with a |
length of 90, but the maximum allowed length is 30. The column |
must be defined with a length of 30 or less before the view can be |
used to get the information you requested. |
|
If your database supports 3-part names and a location qualifier was added |

The label colum is still defined as 90 it should be 30

Column Name Column Type Column Length
------------------------- ----------- -------------
OWNER VARCHAR 128
TNAME VARCHAR 128
TYPE VARCHAR 5
SUBTYPE CHAR 1
MODEL VARCHAR 1
RESTRICTED VARCHAR 1
REMARKS VARCHAR 254
CREATED VARCHAR 1
MODIFIED VARCHAR 1
LAST_USED VARCHAR 1
LABEL VARCHAR 90
LOCATION CHAR 16
OWNER_AT_LOCATION VARCHAR 128
NAME_AT_LOCATION VARCHAR 128
*********************** End Of List ********************

[drbob1]

My catalog/access authority problem is fixed now. Thanks very much!

[kbc2112]

Hi,
Thank You..
When You resolved CICS is working fine...
But now CICS is again down.....