Unable to run Utilities

, , ,
1

Status of Global Database (GDT) (ID = NONE) :
Created at 13-DEC-2009 23:18:49 by DBID:101

DBID VERS --------------- Status: --------------
101 3 LOCAL NETWIDE attached to node(s)

$ adaopr
%ADAOPR-I-STARTED, 14-DEC-2009 13:46:45, Version 3.3.1.08 (Solaris 64Bit)
adaopr: db=101

%ADAOPR-W-ADA255, * Insufficient space in attached buffer pool to process command
%ADAOPR-I-NOPARMOD, No parameter modification possible. Try DBID to re-enable.

Q. how do I re-anable DB? will it fix the space error?

               SHOWIPC for ADABAS 3.3.1.08 (Solaris 64Bit)

DBID Shared Memory Message Queues Semaphores

NET GDT: 6803 CSA: 6845 ???: 6886 USQ:177160 RSQ:176649 SEM:11141128
SVQ: 88074
101 GCB: 13761 CSA: 6882 ATB: 6884 USQ: 88064 CLM: 88065 SEM:22544391
SRV: 88066 SRV: 88067 CLS:11272201
SRV: 88068 SRV: 88069 SDA:11272202
SRV: 88070 SRV: 88071
CLM:202763 CLM:736780

During an ADABCK session I got “ADA255-W-Not enough space in LAB”.

when I tried to initiate an ADAOPR/ADADBM session. I got the above mesg plus 'Try DBID to re-enable"?

Is there a way around this problem without bringing ADABAS down?

sample statistics from a previous High Water Session.

adaopr: di=high_water
ADANUC Version 3.3.1.08
Database 101 High Water Marks on 10-JUN-2009 13:38:55

Area/Entry Size In Use High Water % Date/Time

User Queue 200 30 34 17 10-JUN-2009 10:13:45
Command Queue 200 2 3 1 10-JUN-2009 07:43:25
Hold Queue 10,000 1 229 2 10-JUN-2009 10:14:55
User Limit 3,000 - 201 6 10-JUN-2009 10:09:55
Threads 10 1 10 100 10-JUN-2009 12:09:35
Workpool 500,000 0 50,016 10 10-JUN-2009 07:07:35
ISN Sort 50,000 - 0 0
Complex Search 50,000 - 0 0

Buffer Pool 16,777,216 16,732,160 16,769,024 99 10-JUN-2009 06:46:35

Attached Buffer 819,200 3,072 27,648 3 10-JUN-2009 08:58:37

Protection Area 5,000
Active Area 1,500 - 13 0 10-JUN-2009 11:52:25
WORK Part 2 268 0 0 0
WORK Part 3 58,732 0 3 0 10-JUN-2009 09:30:15
Group Commit 50 0 1 2 10-JUN-2009 06:33:25
Transaction Time 900 - 140 15 10-JUN-2009 08:22:25

arif

env:
Sun Solaris 8 64bit, ADA331/6
Adabas (ADA 3.3.1.8 UX/SUN Solaris)
Natural Runtime (RUN 6.1.1.9 PC/Windows 2000 Server)
Natural (NAT 6.1.1i PC/Windows 2000 Professional)
Entire Net-Work (WCP 2.1.1.38 UX/SUN Solaris)

2

Looks like you will need to modify the nuc parameters (LAB), then stop and start the database.

3

James:

you mean modify the nuc parameters (LAB) to a hgiher value?

Just wondering why ADABAS refuses DB Utilities but has no problem with running Applications?

thanks

4

I suspect the buffers are allocated on a first come, first serve basis. If when the utility is executed against the database the buffers have been fully utilitized by the application code, you will run into this error. It would also occur if you increase the number of users running at the same time.

5

[size=“18”]Hello Forum:

I am trying to copy data from an Ababas File on Unix to an Ababas File on Win XP.

This is what I plan to do:

  1. Make a backup using ADABCK (already done)
  2. Unload the one file (ADAULD) using backup_copy
    backup_copy is a complete offline backup of DB101 (130 Files)
  3. Decompress the file (ADADCU)
  4. Define the new file in Adabas XP
  5. Load the file (ADAMUP) into Adabas XP using existing FDT

Step 1 executed successfully.
Step 2 crashed with the following ADAULD Error Codes.

%ADAULD-F-IOI31, op 5, rc 31 (Invalid RABN)
%ADAULD-F-IOIS1, typ 3, rabn 1, flag 0000000000000000

What is IOI31, op 5, rc 31 (Invalid RABN)
IOIS1, typ 3, rabn 1, flag 0000000000000000

and where can I find an explanation to this error message.

Arif[/size]

$ export ULD001=ADABCK_DB101_100507_ULD001
$ export ULDDTA=ADABCK_DB101_100507_ULDDTA
$ export ULD001=ADABCK_DB101_100507_231700
$ export TEMP1=TEMP1.txt
$ adauld
%ADAULD-I-STARTED, 17-MAY-2010 15:41:11, Version 3.3.1.08 (Solaris 64Bit)
adauld: backup_copy=101,file=41
adauld: ^D
%ADAULD-F-IOI31, op 5, rc 31 (Invalid RABN)
%ADAULD-F-IOIS1, typ 3, rabn 1, flag 0000000000000000
%ADAULD-I-IOCNT, 1 IOs on dataset ULDDTA
%ADAULD-I-IOCNT, 1 IOs on dataset ULDDVT
%ADAULD-I-IOCNT, 9 IOs on dataset ULD001
%ADAULD-I-ABORTED, 17-MAY-2010 15:41:37, elapsed time: 00:00:26
$
$ export BCK001=ADABCK_DB101_100507_231700
$ adabck
%ADABCK-I-STARTED, 17-MAY-2010 15:54:41, Version 3.3.1.08 (Solaris 64Bit)
adabck: db=101
%ADABCK-I-DBOFF, database 101 accessed offline
adabck: read_check
%ADABCK-I-BKCHSUC, backup save set successfully checked
%ADABCK-I-IOCNT, 40 IOs on dataset ASSO
%ADABCK-I-IOCNT, 12732 IOs on dataset BCK001
%ADABCK-I-TERMINATED, 17-MAY-2010 15:55:00, elapsed time: 00:00:19
$