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