sábado, fevereiro 04, 2023

NAT0777 Buffer pool full

O buffer pool é uma área de armazenamento na qual os programas do Natural são colocados em preparação para sua execução. Os programas são movidos para dentro e para fora do buffer pool conforme os usuários Natural solicitam objetos Natural. Conceitualmente, ele desempenha uma função semelhante à de um sistema operacional ao carregar programas dentro e fora de uma área reentrante. O buffer pool Natural é parte integrante do Natural em todos os ambientes suportados. Tamanhos de página variáveis permitem ajuste flexível, mas fazer a lógica de buffer pool mais sofisticadas, em particular relativo em matéria de paralelismo.

Buffer pool full

Os usuários reclaramaram sobre o NAT0777 ao pesquisar o buffer pool - opção L

  12:44:22             ***** NATURAL SYSBPM UTILITY *****             23/01/2023
  BPNAME NATGBP                  - Main Menu -                   Type Global Nat
  BPPROP OFF                                                       Loc CPAC NAT4
                                                                                
                                                                                
             Object Functions                Object Pool Statistics             
                                                                                
             L  List Objects                 A  Buffer Pool                     
             D  Delete Objects               C  BP Cache                        
             I  Directory Information                                           
             H  Hexadecimal Display          Other Functions                    
             W  Write to Work File                                              
             X  Display Sorted Extract       S  Select Buffer Pool              
             ?  Help                         B  Blacklist Maintenance           
             .  Exit                         P  Preload List Maintenance        
                                                                                
     Code .. L   Library ... *_______                                           
                 Object .... *_______________________________________           
                 DBID ...... 0____  FNR .. 0____  Object Pool ... * (B,C,*)     
                                                                                
                                                                                
 Command ===>                                                                   
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help        Exit  Last        Flip

Depois de alguns PF8 (avançar) dava erro de buffer pool full - realmente estamos com problema

  08:26:22             ***** NATURAL SYSBPM UTILITY *****             23/01/2023
  BPNAME NATGBP                 - List Objects -                 Type Global Nat
  BPPROP OFF                                                       Loc CPAC NAT4
  C  Library  Obje +------ SYSBPM Internal Error Report -------+ st Action      
     *_______ *___ |                                           | ___ ________   
  __ PROSOE   ADIN | Natural system error 0777 has occurred.   | 123 00:01:13.2 
  __ PROSOE   AEMP | Buffer pool full.                         | 123 08:26:00.2 
  __ PROSOE   AAMP |                                           | 122 23:18:54.6 
  __ SUPORTE2 DBAM | Message class .. Error                    | 120 deleted    
  __ SYSMAIN  SMNA | Error class .... System                   | 123 08:23:54.4 
  __ PROSOE   A@00 | Error type ..... Runtime                  | 123 02:14:46.4 
  __ PROSOE   AEIP | Program ........ BPMIN                    | 123 08:25:33.0 
  __ PROSOE   ADIM | Line number .... 4445                     | 122 23:12:14.0 
  __ PROSOE   AEIM |                                           | 123 08:25:36.1 
  __ SYSTEM   AACP |                                           | 123 06:15:46.2 
  __ SYSLIBS  NAT0 | Press ENTER to continue SYSBPM,           | 123 08:25:46.6 
  __ SYSLIB   FUL- |       PF3   to exit SYSBPM.               | 122 15:56:15.2 
  __ PROSOE   AEMH +-------------------------------------------+ 123 08:25:55.0 
  __ PROSOE   AEIM812    240   15 B    20230123 08:16:18.3  20230123 08:20:38.3 
                                                                                
                                                                                
 Command ===>                                                                   
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help        Exit  Last        --    -     +     ++    <     >     Canc

Explicação - O buffer pool Natural está cheio. Com o Natural Versão 2, o programa Natural catalogado deve ser carregado no buffer pool do Natural. Se não houver espaço suficiente disponível, o programa não poderá ser executado.

 09:35:24               ***** NATURAL HELP UTILITY *****              23/01/2023
 Library SUPORTE2      - Natural System Message NAT0777 -             Page 1    
                                                                                
    Buffer pool full.                                                           
                                                                                
 Tx *** Short Text ***                                                          
                                                                                
    Buffer pool full.                                                           
                                                                                
 Ex *** Explanation ***                                                         
                                                                                
    The Natural buffer pool is full. With Natural Version 2,                    
    the cataloged Natural program must be loaded into the                       
    Natural buffer pool. If there is not enough space available,                
    the program cannot be executed.                                             
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                    More ...    
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Menu  Exit        Print             +                       Canc 

Recomendação - Contacte o administrador oatural, ok, sou eu e não sei como resolve, brincadeira, zoeira, vamos ter que aumentar essa area de buffer pool

 09:35:40               ***** NATURAL HELP UTILITY *****              23/01/2023
 Library SUPORTE2      - Natural System Message NAT0777 -             Page 2    
                                                                                
    Buffer pool full.                                                           
                                                                                
 Ac *** Recommended Action ***                                                  
                                                                                
    Contact your Natural administrator.                                         
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                                
                                                                    Last Page   
 Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
       Help  Menu  Exit        Print       -                 --          Canc

Não tem outra alternativa, temos que stopar e startar uma buffer pool maior, vamos subir a NATGBP (global) 15M para 25M - job para stop do buffer pool global

MEMBER=GBNASTOP 000011 REC SAVE:23.01.2023 11:17 BY   USERID DBA29  R=00000001
DSN=NATURAL.V414.JOBS                                   VOL=PRL302 UNIT=1525    
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
//AAFSNATB JOB (AAAC,OSS),DIBD,CLASS=A,MSGCLASS=A                               
//*UQ ALLOW                                                                     
//* --------------------------------------------------------                    
//*               STOP NATURAL GLOBAL BUFFER POOL                               
//* --------------------------------------------------------                    
//STOPNAT  EXEC PGM=NATGBP41,PARM='CF=STOPNAT'                                  
//STEPLIB  DD DSN=ADA5.LOADLIB,DISP=SHR                                         
//SYSUDUMP DD SYSOUT=*                                                          
//STOPNAT  DD *                                                                 
F,BPN=NATGBP,S=NAT4                                                             
//*

Resultado

1                       J E S 2  J O B  L O G  --  S Y S T E M  C P A C  --  N O D E  J E S 2            
0 
 10.33.32 JOB03078 ---- MONDAY,    23 JAN 2023 ----
 10.33.32 JOB03078  TSS7000I DBA29 Last-Used 23 Jan 23 10:22 System=CPAC Facility=TSO
 10.33.32 JOB03078  TSS7001I Count=13909 Mode=Fail Locktime=None Name=DBA ADABAS ID29
 10.33.32 JOB03078  $HASP373 AAFSNATB STARTED - INIT K    - CLASS S - SYS CPAC
 10.33.32 JOB03078  IEF403I AAFSNATB - STARTED - TIME=10.33.32
 10.33.32 JOB03078  GBP0101 AAFSNATB: Specified parms: CF=STOPNAT
 10.33.32 JOB03078  GBP0201 AAFSNATB: Reading parm input from file STOPNAT
 10.33.32 JOB03078  GBP0199 AAFSNATB: Natural Global Buffer Pool Manager Version 414
 10.33.32 JOB03078  GBP0103 AAFSNATB: Input from file: F,BPN=NATGBP,S=NAT4
 10.33.32 JOB03078  GBP0115 AAFSNATB: GBP still in use:   NATGBP  /NAT4 - DIR=15F1AA20 ADDR=15019000
 10.33.32 JOB03078 *85 GBP0118 AAFSNATB: Reply Y to force shutdown of GBP
 10.33.46 JOB03078  R 85,Y       
 10.33.46 JOB03078  GBP0113 AAFSNATB: GBP stopped:    NATGBP  /NAT4 - DIR=15F1AA20 ADDR=15019000
 10.33.46 JOB03078  GBP0202 AAFSNATB: EOF encountered reading file STOPNAT
 10.33.46 JOB03078  -                                              --TIMINGS (MINS.)--            -----PAGING COUNTS----
 10.33.46 JOB03078  -STEPNAME PROCSTEP    RC   EXCP   CONN    TCB    SRB  CLOCK   SERV  WORKLOAD  PAGE  SWAP   VIO SWAPS
 10.33.46 JOB03078  -STOPNAT              00     28      8    .00    .00     .2   2884  SYSTEM       0     0     0     0
 10.33.46 JOB03078  IEF404I AAFSNATB - ENDED - TIME=10.33.46
 10.33.46 JOB03078  -AAFSNATB ENDED.  NAME-DIBD                 TOTAL TCB CPU TIME=    .00 TOTAL ELAPSED TIME=    .2
 10.33.46 JOB03078  $HASP395 AAFSNATB ENDED
0------ JES2 JOB STATISTICS ------                                                                                                   
-  23 JAN 2023 JOB EXECUTION DATE                                                                                                    
-           14 CARDS READ                                                                                                            
-           57 SYSOUT PRINT RECORDS                                                                                                  
-            0 SYSOUT PUNCH RECORDS                                                                                                  
-            3 SYSOUT SPOOL KBYTES                                                                                                   
-         0.24 MINUTES EXECUTION TIME                                                                                                
UQS0009 - END OF DATASET.

Start a buffer pool global - 25 mb

MEMBER=GBEDSTRT 000011 REC SAVE:23.01.2023 11:17 BY   USERID DBA29  R=00000001
DSN=NATURAL.V414.JOBS                                   VOL=PRL302 UNIT=1525    
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
//AAFSEGBP JOB (AAAC,OSS),DIBD,CLASS=A,MSGCLASS=A                               
//*UQ ALLOW                                                                     
//* --------------------------------------------------                          
//*         START EDITOR GLOBAL BUFFER POOL                                     
//* --------------------------------------------------                          
//STARTNAT EXEC PGM=NATGBP41,                                                   
//   PARM='BPN=NATGBP,S=NAT4,N=(25M,XA,2),R=N'                                  
//STEPLIB  DD DSN=ADA5.LOADLIB,DISP=SHR                                         
//SYSUDUMP DD SYSOUT=A                                                          
//GBPPRINT DD SYSOUT=A                                                          
//SYSPRINT DD SYSOUT=A

Resultado

1                       J E S 2  J O B  L O G  --  S Y S T E M  C P A C  --  N O D E  J E S 2            
0 
 10.34.30 JOB03079 ---- MONDAY,    23 JAN 2023 ----
 10.34.30 JOB03079  TSS7000I DBA29 Last-Used 23 Jan 23 10:33 System=CPAC Facility=BATCH
 10.34.30 JOB03079  TSS7001I Count=13910 Mode=Fail Locktime=None Name=DBA ADABAS ID29
 10.34.30 JOB03079  $HASP373 AAFSEGBP STARTED - INIT K    - CLASS S - SYS CPAC
 10.34.30 JOB03079  IEF403I AAFSEGBP - STARTED - TIME=10.34.30
 10.34.30 JOB03079  GBP0199 AAFSEGBP: Natural Global Buffer Pool Manager Version 414
 10.34.30 JOB03079  GBP0101 AAFSEGBP: Specified parms: BPN=NATGBP,S=NAT4,N=(25M,XA,2),R=N
 10.34.30 JOB03079  GBP0111 AAFSEGBP: GBP active:     NATGBP  /NAT4 - DIR=15F1AA20 ADDR=1220D000
 10.34.30 JOB03079  -                                              --TIMINGS (MINS.)--            -----PAGING COUNTS----
 10.34.30 JOB03079  -STEPNAME PROCSTEP    RC   EXCP   CONN    TCB    SRB  CLOCK   SERV  WORKLOAD  PAGE  SWAP   VIO SWAPS
 10.34.30 JOB03079  -STARTNAT             00     27      6    .00    .00     .0   1114  BATCH        0     0     0     0
 10.34.30 JOB03079  IEF404I AAFSEGBP - ENDED - TIME=10.34.30
 10.34.30 JOB03079  -AAFSEGBP ENDED.  NAME-DIBD                 TOTAL TCB CPU TIME=    .00 TOTAL ELAPSED TIME=    .0
 10.34.30 JOB03079  $HASP395 AAFSEGBP ENDED
0------ JES2 JOB STATISTICS ------                                                                                                   
-  23 JAN 2023 JOB EXECUTION DATE                                                                                                    
-           13 CARDS READ                                                                                                            
-           53 SYSOUT PRINT RECORDS                                                                                                  
-            0 SYSOUT PUNCH RECORDS                                                                                                  
-            3 SYSOUT SPOOL KBYTES                                                                                                   
-         0.00 MINUTES EXECUTION TIME 

Observação, ao parar o buffer pool parou tudo, jobs cancelaram, usuários cairam com as consultas no banco - Não temos outra alternativa pois estamos recebendo o NAT0777

0 comentários:

Enviar um comentário