IBM Mainframe Forum

[samb01]

Hello,

how can i know if a catalog is full ?

This is my catalog :

Select all

Command - Enter "/" to select action                        Tracks %Used   XT 
-------------------------------------------------------------------------------
         KATXXXX.GTXD1.RG.TER001                             31650    ?   112 
***************************** End of Data Set list ****************************

Thank's for your help.

[steve-myers]

First of all, the dataset you are showing does not appear to be a catalog, but this analysis is based on the name. Second, some classes of datasets - VSAM as well as PDSE- are difficult to analyze. The large number of extents may indicate the dataset is nearly "full," but the dataset is not quite at the extent limit. Third, why do you think this is a catalog issue???

[enrico-sorichetti]

how can i know if a catalog is full ?

by looking at a LISTCAT listing

[samb01]

It's a VSAM,this is the result of a LISTCAT

Select all

CLUSTER ------- 00000000000000000000000000000000000000000000                 
     HISTORY                                                                 
       DATASET-OWNER-----(NULL)     CREATION--------2011.024                 
       RELEASE----------------2     EXPIRATION------0000.000                 
     SMSDATA                                                                   
       STORAGECLASS ---PREP0001     MANAGEMENTCLASS---(NULL)                   
       DATACLASS --------(NULL)     LBACKUP ---0000.000.0000                   
       CA-RECLAIM---------(YES)                                               
       EATTR-------------(NULL)                                               
       BWO STATUS------00000000     BWO TIMESTAMP---00000 00:00:00.0           
       BWO---------------(NULL)                                               
     RLSDATA                                                                   
       LOG ----------------(NULL)   RECOVERY REQUIRED --(NO)     FRLOG --------
---(NULL)                                                                     
       VSAM QUIESCED -------(NO)    RLS IN USE ---------(NO)                   
       LOGSTREAMID-----------------------------(NULL)                         
       RECOVERY TIMESTAMP LOCAL-----X'0000000000000000'                       
       RECOVERY TIMESTAMP GMT-------X'0000000000000000'                       
     PROTECTION-PSWD-----(NULL)     RACF----------------(NO)                   
     ASSOCIATIONS                                                             
       DATA-----CATALOG.PROD1.PA.SEQ001                                       
       INDEX----CATALOG.PROD1.PA.SEQ001.CATINDEX                               
   DATA ------- CATALOG.PROD1.PA.SEQ001                                       
     HISTORY                                                                   
       DATASET-OWNER-----(NULL)     CREATION--------2011.024                   
       RELEASE----------------2     EXPIRATION------0000.000                   
       ACCOUNT-INFO-----------------------------------(NULL)                   
      PROTECTION-PSWD-----(NULL)     RACF----------------(NO)                   
      ASSOCIATIONS                                                             
        CLUSTER--00000000000000000000000000000000000000000000                   
      ATTRIBUTES                                                               
        KEYLEN----------------45     AVGLRECL------------4086     BUFSPACE------
-----41984     CISIZE-------------20480                                         
        RKP--------------------9     MAXLRECL-----------32400     EXCPEXIT------
----(NULL)     CI/CA-----------------37                                         
        BUFND------------------5     STRNO------------------4                   
        SHROPTNS(3,4)      SPEED     UNIQUE           NOERASE     INDEXED       
NOWRITECHK     NOIMBED       NOREPLICAT                                         
        UNORDERED        NOREUSE     SPANNED        NOECSHARE     ICFCATALOG   
      STATISTICS                                                               
        REC-TOTAL--------------0     SPLITS-CI----------31477     EXCPS---------
---------0                                                                     
        REC-DELETED-------277683     SPLITS-CA-----------1332     EXTENTS-------
-------114                                                                     
        REC-INSERTED-----------0     FREESPACE-%CI----------0     SYSTEM-TIMESTA
MP:                                                                             
        REC-UPDATED------------0     FREESPACE-%CA----------0          X'0000000
000000000'                                                                     
        REC-RETRIEVED----------0     FREESPC-------1614028800                   
      ALLOCATION                                                               
        SPACE-TYPE------CYLINDER     HI-A-RBA------1614028800                   
        SPACE-PRI-----------1000     HI-U-RBA------1614028800                   
        SPACE-SEC-------------10                                               
      VOLUME                                                                   
        VOLSER------------PPRP58     PHYREC-SIZE--------10240     HI-A-RBA------
1614028800     EXTENT-NUMBER--------114                                         
        DEVTYPE------X'3010200F'     PHYRECS/TRK------------5     HI-U-RBA------
1614028800     EXTENT-TYPE--------X'00'                                         
        VOLFLAG------------PRIME     TRACKS/CA-------------15                   
        EXTENTS:                                                               
        LOW-CCHH-----X'19E60000'     LOW-RBA----------------0     TRACKS--------
-----15000                                                                     
        HIGH-CCHH----X'1DCD000E'     HIGH-RBA-------757759999                   
        LOW-CCHH-----X'034F0000'     LOW-RBA--------757760000     TRACKS--------
-------150                                                                     
        HIGH-CCHH----X'0358000E'     HIGH-RBA-------765337599                   
        LOW-CCHH-----X'03C30000'     LOW-RBA--------765337600     TRACKS--------
-------150                                                                     
        HIGH-CCHH----X'03CC000E'     HIGH-RBA-------772915199                   
        LOW-CCHH-----X'03CD0000'     LOW-RBA--------772915200     TRACKS--------
-------150                                                                     
        HIGH-CCHH----X'03D6000E'     HIGH-RBA-------780492799                   
        LOW-CCHH-----X'017F0000'     LOW-RBA--------780492800     TRACKS--------

What is the maximum of extent ?

Thank's

[steve-myers]

It's a VSAM ... What is the maximum of extent ?

Duh! All catalogs are VSAM these days.

I realize English is not your first language, but "What is the maximum of extent" is unintelligible.

Most VSAM usage statistics for catalogs are unreliable, and that appears to be the case here. They are unreliable because catalogs are seldom closed properly. For normal VSAM you look for high allocated RBA and high used RBA, though that's not reliable because high used RBA may not reflect deleted records very well. Here they are identical,

The only reliable test is to try to define a new catalog entry. If the result is a message about the catalog being full, you have to take it at its word.

Based on the extremely high allocated space for this catalog, I'd guess it's full, but it most likely has severe structural problems. I'd take this to your storage management people. Copying catalogs, especially catalogs with major structural problems, is not a task for a beginner. It's been at roughly 20 years since I did any catalog copying. I really didn't know enough to recover from a major problem then, and it's still true. There were issues I didn't understand then, especially reestablishing alias pointers, and I'd have to relearn that now. Like I said, dump this can of worms ("can of worms" is an idiom in English that usually means a difficult problem) on your storage management people. If you've inherited the storage management job, all I can say is, Good luck!

[halfteck]

In answer to one of your questions, you are allowed 123 seperate extents of space so you can have 12 more 'lots' of 10 cylinders.

I would also suggest, it seems inconceivable to me that a catalog would have so much space allocated, so are you sure its a calaogue. On my entire LPAR there are only 20 cylinders worth of usercatalogue space availaboe.

Also in your listing you have 1332 CA splits, unless this has changed, with later releases of VSAM, that equates to an extra 1332 cylinders allocated in addition to the original 1000 cylinders.

If possible i think there may be savings to be gained if the cluster could be re organised, dont know if you can though, as other son here have suggested best advice is to speak with the storage management people.

Lastly i suspect the listing you supplied was from your installations master catalogue, rather than a usercat where your datasets will be stored (assumming your not a systems programmer that is)

Hope that helps

[samb01]

Hello,

yes you guested English is not my first language. (Itès not so difficult to guess it )

Thank's for your help, but i can swear : It's a usercat :

USERCATALOG --- CATALOG.PROD1.PA.SEQ001
IN-CAT --- CATALOG.MVSICFM.VSYS001
HISTORY
RELEASE----------------2
VOLUMES
VOLSER------------PPRP58 DEVTYPE------X'3010200F' VOLFLAG-------
-----PRIME
ASSOCIATIONS
ALIAS----PROBPA
***

There are more than 1322724 datasets.....

I think i will dump and delete several datasets and ask for reorganize the usercat.

[mongan]

With over a million data sets in one catalog I think you should start looking at making a new catalog design. Isn't this also a performance issue with that many data sets in one catalog? Do all these data sets have the same high level qualifier? How is you data backup concept look? Lots of issues here.