O erro apresentado no ambiente Natural/Adabas está relacionado principalmente à ocorrência da mensagem NAT3072 – User queue overflow. Essa ocorrência está diretamente associada à User Queue do Adabas, estrutura utilizada para armazenar informações temporárias relacionadas à sessão, ao usuário e ao processamento em execução. Quando a capacidade disponível nessa área é atingida, ocorre um overflow (estouro da User Queue), fazendo com que o ambiente não consiga armazenar novas informações necessárias para a continuidade do processamento. Como consequência, a execução do programa pode ser interrompida e a sessão pode entrar em um estado inconsistente. A partir dessa condição, pode ocorrer também a mensagem NAT0856 – Automatic logon with invalid logon data, indicando uma falha durante o processo de logon automático. Nesse cenário, o Natural pode tentar utilizar informações de sessão que ficaram inconsistentes ou incompletas em decorrência do problema ocorrido anteriormente na User Queue. Na sequência, também pode ser apresentada a mensagem NAT9982 – Error occurred during session termination. Esse erro ocorre quando o Natural tenta finalizar a sessão, normalmente como consequência da falha anterior, mas encontra estruturas ou informações inconsistentes que impedem o encerramento normal do ambiente. Dessa forma, as mensagens NAT3072, NAT0856 e NAT9982 podem ser entendidas como parte de uma mesma cadeia de eventos. O problema tem como origem principal o esgotamento da User Queue no Adabas, que provoca uma falha no processamento, compromete o estado da sessão e, posteriormente, pode gerar erros relacionados ao logon automático e ao encerramento da sessão. Em resumo, trata-se de uma condição que começa com o overflow da User Queue, afetando diretamente a sessão do usuário e podendo provocar uma sequência de erros no Natural até a interrupção ou encerramento forçado do processamento.
IEF142I AAFSNATB NATURAL DB230 - STEP WAS EXECUTED - COND CODE 0000 IEF142I AAFSNATB NATURAL DB240 - STEP WAS EXECUTED - COND CODE 0000 IEF142I AAFSNATB NATURAL DB110 - STEP WAS EXECUTED - COND CODE 0000 IEF142I AAFSNATB NATURAL DB210 - STEP WAS EXECUTED - COND CODE 0000 IEF142I AAFSNATB NATURAL DB140 - STEP WAS EXECUTED - COND CODE 0000 IEF142I AAFSNATB NATURAL DB141 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB150 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB160 - STEP WAS EXECUTED - COND CODE 0000 IEF142I AAFSNATB NATURAL DB170 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB180 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB190 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB130 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB120 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB100 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB241 - STEP WAS EXECUTED - COND CODE 0000 IEF142I AAFSNATB NATURAL DB020 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB030 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB040 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB050 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB060 - STEP WAS EXECUTED - COND CODE 0008 IEF142I AAFSNATB NATURAL DB070 - STEP WAS EXECUTED - COND CODE 0000 -------------------------------------------------------------------------------- OP=S CL=ALL IN=ALL JB=AAFSNATB,02616 DS=3 SI=CC LR=1 LL=80 PP=0 DC= RL=999999 AD=S DE= SC= PT= SQ=C RR=0 OC= SD=2000 25.08.2023, 11:17:34
NAT3072 User queue overflow
Banco id 1501NAT3072 User queue overflow. DB/FNR/Subcode 150/15/7. NAT0856 Automatic logon with invalid logon data; logon failed. NAT3072 User queue overflow. DB/FNR/Subcode 150/0/7. 1NAT9982 Error occurred during session termination UQS0009 - END OF DATA SET.
Descrição do Erro
A recomendação é aumentar o parametro NU; 12:31:48 ***** NATURAL HELP UTILITY ***** 25/08/2023
Library SUPORTE2 - Natural System Message NAT3072 - Page 1
User queue overflow. DB/FNR/Subcode :1:/:2:/:3:.
Tx *** Short Text ***
User queue overflow. DB/FNR/Subcode .../.../....
Ex *** Explanation ***
An overflow occurred in the user queue or the user file list pool.
Ac *** Recommended Action ***
Ask your database administrator to increase the value
used for the NU parameter.
Last Page
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Menu Exit Print Canc
High Water Marks
Pelo Sysaos opção (A/U/H - banco 150) o parametro NU atingiu 100% caraca; 11:25:03 ***** A D A B A S BASIC SERVICES ***** 2023-08-25
DBID 150 - High Water Marks - PACUH02
Pool / Queue I Size I Used I %Used I Date Time I
------------------------------------------------------------------------------
Attached Buffer(NAB) I 655360 I 32768 I 5,0 I I
Command Queue (NC) I 15360 I 192 I 1,2 I 2023-08-25 11:25:02 I
Format Pool (LFP) I 1024000 I 100948 I 9,8 I 2023-08-23 16:08:15 I
Hold Queue (NH) I 84056 I 252 I 0,2 I 2023-08-22 09:30:46 I
ISN-List Table (LI) I 80000 I 1064 I 1,3 I 2023-08-23 15:30:00 I
Seq. Cmd. Table(LQ) I 50000 I 1116 I 2,2 I 2023-08-21 12:27:21 I
User Queue (NU) I 112112 I 112112 I 100,0 I 2023-08-25 10:03:12 I
Unique DE Pool (DUQ) I 50000 I 0 I 0,0 I I
Security Pool (LCP) I 2000 I 0 I 0,0 I I
UQ File List (UQF) I 33960 I 25344 I 74,6 I 2023-08-25 10:03:12 I
ATM Trans. IDs (XID) I 0 I 0 I 0,0 I I
Work Pool (LWP) I 1024000 I 333716 I 32,5 I 2023-08-23 11:22:01 I
Redo Pool (LRDP)I 0 I 0 I 0,0 I I
PF1----- PF2------ PF3------ PF4------ PF6----- PF7----- PF8----- PF12-----
Help Exit Refresh Menu
Alterando Parametro
Vamos alterar o parametro de NU de 350 para 1000MEMBER=ADAP150 000062 REC SAVE:04.07.2013 07:47 BY USERID DBAP124 R=00000021 DSN=AAB.DIBD.ADAPARM LIB=S1 VOL=PRL303 UNIT=1526 ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8 ADARUN LOGSB=NO <=== LOG SEARCH BUFFER ADARUN LOGVB=NO <=== LOG VALUE BUFFER ADARUN LP=10000 <=== LENGTH OF DATA PROTECTION AREA*10000 ADARUN LQ=50000 <=== LENGTH OF SEQUENTIAL COMMAD TABLE ADARUN LS=300032 <=== LENGTH OF SORT AREA * ADARUN LU=65535 <=== LENGTH OF INTERMEDIATE USER BUFFER * 44000 ADARUN LWP=1024000 <=== LENGTH OF ADABAS WORK POOL * 1500000 04/99 96 ADARUN LWKP2=1200 <=== LENGTH WORK PART-2 * NEW * ADARUN MIRROR=NO <=== DATA BASE MIRRORING ADARUN NAB=160 <=== NUMBER OF ATTACHED BUFFERS * 25 ADARUN NC=80 <=== NUMBER OF COMMAND QUEUE ELEMENTS ADARUN NH=3000 <=== NUMBER OF HOLD QUEUE ELEMENTS ADARUN NISNHQ=750 <=== NUMBER OF ISNS IN HOLD QUEUE F/USER /97 ADARUN NONDES=NO <=== DISALOW SEARCHES USING NONDESCRIPTORS 9/3/4/97 ADARUN NQCID=75 <=== NUMBER OF CID PER USER * 10 ADARUN NSISN=250 <=== NUMBER OF ISNS PER TBI ELEMENT * 200 ADARUN NT=3 -<=== NUMBER OF THREADS * 13 - 15/02/2000 ADARUN NU=350 <=== NUMBER OF USER QUEUE ELEMENTS ADARUN OPENRQ=NO <=== OPEN COMMAND REQUIRED * ADARUN PLOGMIR=NO <=== PROTECTION LOG MIRRORING
Parando e Colocar no Ar o Banco
Este banco 150 não tem ninguem acessando.1 J E S 2 J O B L O G -- S Y S T E M C P A C -- N O 0 23.56.52 STC06497 ---- THURSDAY, 10 AUG 2023 ---- 23.56.52 STC06497 IEF695I START DBA00150 WITH JOBNAME DBA00150 IS ASSIGNED TO 23.56.52 STC06497 $HASP373 DBA00150 STARTED 23.56.52 STC06497 IEF403I DBA00150 - STARTED - TIME=23.56.52 23.56.52 STC06497 ADAN02 00150 Nucleus run without protection log 23.56.52 STC06497 ADAL01 00150 2023-08-10 23:56:51 CLOG not active 23.56.52 STC06497 ADAN03 00150 ADABAS coming up 23.56.53 STC06497 ADAN19 00150 Buffer flush is a s y n c h r o n o u s 23.56.53 STC06497 ADAN01 00150 A D A B A S V7.4.4 is active 23.56.53 STC06497 ADAN01 00150 MODE = MULTI 23.56.53 STC06497 ADAN01 00150 Running without recovery log 11.45.30 STC06497 ---- FRIDAY, 25 AUG 2023 ---- 11.45.30 STC06497 ADAN51 00150 2023-08-25 11:45:30 Operator type-in: ADAEND 11.45.30 STC06497 ADAN42 00150 2023-08-25 11:45:30 Function accepted 11.45.30 STC06497 ADAM97 00150 This ASCB/initiator will be terminated by MVS a 11.45.31 STC06497 IEF404I DBA00150 - ENDED - TIME=11.45.31 11.45.31 STC06497 IEF352I ADDRESS SPACE UNAVAILABLE 11.45.31 STC06497 $HASP395 DBA00150 ENDED 0------ JES2 JOB STATISTICS ------ -------------------------------------------------------------------------------- OP=S CL=ALL IN=ALL JB=DBA00150,06497 DS=1 SI=SM LR=1 LL=80 PP=0 DC= RL=999999 AD=J DE= SC= PT= SQ=C RR=0 OC= SD=2000 25.08.2023, 12:13:47
Colocando o Banco
Colocando no ar o banco;1 J E S 2 J O B L O G -- S Y S T E M C P A C -- N O
0
11.45.42 STC03163 ---- FRIDAY, 25 AUG 2023 ----
11.45.42 STC03163 IEF695I START DBA00150 WITH JOBNAME DBA00150 IS ASSIGNED TO
11.45.42 STC03163 $HASP373 DBA00150 STARTED
11.45.42 STC03163 IEF403I DBA00150 - STARTED - TIME=11.45.42
11.45.42 STC03163 ADAN02 00150 Nucleus run without protection log
11.45.42 STC03163 ADAL01 00150 2023-08-25 11:45:42 CLOG not active
11.45.42 STC03163 ADAN03 00150 ADABAS coming up
11.45.42 STC03163 ADAN19 00150 Buffer flush is a s y n c h r o n o u s
11.45.42 STC03163 ADAN01 00150 A D A B A S V7.4.4 is active
11.45.42 STC03163 ADAN01 00150 MODE = MULTI
11.45.42 STC03163 ADAN01 00150 Running without recovery log
UQS0009 - END OF DATA SET.
1 //DBA00150 JOB MSGLEVEL=1
2 //STARTING EXEC DBA00150
3 XXDBA00150 PROC ADA=N,LOG=P
XX*UQ ALLOW
XX* ADA=N --> NORMAL (ADAP150N)
XX* ADA=A --> ABEND (ADAP150A)
XX* LOG=P --> C/PLOG (ADA150PP)
--------------------------------------------------------------------------------
OP=S CL=ALL IN=ALL JB=DBA00150,03163 DS=1 SI=SM LR=1 LL=80 PP=0 DC= RL=999999
AD=J DE= SC= PT= SQ=C RR=0 OC= SD=2000 25.08.2023, 12:14:57
Depois de aumentar esse parametro nunca mais deu erro
0 comentários:
Enviar um comentário