ca.portal.admin

ADS question

Discussion created by ca.portal.admin on Dec 2, 2006
Hi:

I have an application that accesses a record in an area that is
sometimes offline for batch processing. I have tried to trap the 0966
that results from trying to CALC to that record so I can code around it
and keep our application up. I thought I could check the ERROR-STATUS
from a READY, but I have found that READY statements that are coded are
not actually executed until you execute a DML command, such as OBTAIN.
At least it appears that way when I ADS-Alive it.

Any ideas on how I can determine if an area is off-line before I try to
issue a DML command?

Thanks.

Tim Gortner
Sr. Consultant - Sogeti USA LLC
Iowa Department of Human Services
DDM Medical Systems and Data Warehousing
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Retrieval on Production
"Hi Luis,

In IDD in your production CV for each dictionary display the userid. Set the
AUTHORITY FOR DISPLAY (ALL) or select the entities where they will be able
to update/display.

Cheers

Sam Mowbray
b.Data

From: luish@BR.IBM.COM
Reply-To: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Retrieval on Production
Date: Sun, 3 Dec 2006 03:05:17 -0200

HI,

I use IDMS Internal security and I need to create a user in my
production environment only with retrieval capabilities.

I need to use ADSC, MAPC, IDD but only in retrieval mode.

How is the best way to do that ?



Luís
+55 11 8339-0102
IBM Global Services
=========================================
_________________________________________________________________
AdvertisemSent: Fresh jobs daily. Stop waiting for the newspaper. Search now!
www.seek.com.au
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Eseek%2Ecom%2Eau&_t=757263760&_r=Hotmail_EndText_Dec06&_m=EXT
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Retrieval on Production
"HI,

I use IDMS Internal security and I need to create a user in my
production environment only with retrieval capabilities.

I need to use ADSC, MAPC, IDD but only in retrieval mode.

How is the best way to do that ?



Luís
+55 11 8339-0102
IBM Global Services
=========================================
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Print Space for subarea
"Are you sure your IDMS release matches the documentation.
We are release 14 and print space on sub-areas are not supported.

I am just looking at the same thing, except we do not use subareas just
offset. My best advice is to split the area into several files so each
subarea has its own file(s), then you can do a print space for file. You
can easily split the existing file(s) using sort, culprit or fileaid.

Tommy Petersen
110 Cokesbury Rd
Room 542H
Lebanon, NJ 08833

Phone:
Internal 200 - 3699
External (908) 236-3699
Fax: (908) 236-3692




Buz Williams
<buz.williams@GMA
IL.COM> To
Sent by: IDMS IDMS-L@LISTSERV.IUASSN.COM
Public Discussion cc
Forum
<IDMS-L@LISTSERV. Subject
IUASSN.COM> Print Space for subarea


12/04/2006 08:16
AM


Please respond to
IDMS Public
Discussion Forum
<IDMS-L@LISTSERV.
IUASSN.COM>






Does anyone know how I can get space utilization information on subareas?

The Utility manual show syntax of PRINT SPACE FOR AREA
PSDICUST.SDI-CONTRCT-AREA SUBAREA CONTRCT; but that gets a syntax error on
the token SUBAREA, so apparently the documentation is incorrect.

Also, it seems insane to me that I would have to specify each and every
subarea. I inherited this system and had never even heard of subareas. Now
I
need to support them.

Personally, I think it's a horrible idea, since there are so many ways to
hide problems. This all started because we started getting 1211 on store in
an area that was 76% utilized. It took me two days to figure out it was the
subarea concept that was screwing me up.

Any suggestions for getting out of this mess?

Buz Williams
Ateras
Dallas, TX
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: [IDMSVENDOR-L] Print Space for subarea
"Buzz,
a few comments:

print space by subarea only works at a certain release (perhaps 16 and
above?) - also, if i recall correctly, you must have symbolics defined (in
the DMCL and schema) for the subarea method to work

the only surefire release - independent way of getting ""subarea""
utilization stats (that I am aware of) is to run a DBAN specifying page
ranges and requesting the appropriate AREA report


Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
choelscher@humana.com




The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Print Space for subarea
"Does anyone know how I can get space utilization information on subareas?

The Utility manual show syntax of PRINT SPACE FOR AREA
PSDICUST.SDI-CONTRCT-AREA SUBAREA CONTRCT; but that gets a syntax error on
the token SUBAREA, so apparently the documentation is incorrect.

Also, it seems insane to me that I would have to specify each and every
subarea. I inherited this system and had never even heard of subareas. Now I
need to support them.

Personally, I think it's a horrible idea, since there are so many ways to
hide problems. This all started because we started getting 1211 on store in
an area that was 76% utilized. It took me two days to figure out it was the
subarea concept that was screwing me up.

Any suggestions for getting out of this mess?

Buz Williams
Ateras
Dallas, TX
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Print Space for subarea
"Buz,
PRINT SPACE FOR SUBAREA came in with R16 SP#2 I believe.

I suggest you use DBAN report 2 specifying:
AREA areaname PAGE start-of-subarea TO end-of-subarea

Steve

Steve Terry
BT
Tel: +44 (0)121 230 7728

British Telecommunications plc
Registered office: 81 Newgate Street London EC1A 7AJ
Registered in England no. 1800000

This electronic message contains information from British
Telecommunications plc which may be privileged and confidential. The
information is intended to be for the use of the individual(s) or entity
named above. If you are not the intended recipient, be aware that any
disclosure, copying, distribution or use of the contents of this
information is prohibited. If you have received this electronic message
in error, please notify us by telephone or e-mail (to the number or
address above) immediately.-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Buz Williams
Sent: 04 December 2006 13:17
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: Print Space for subarea

Does anyone know how I can get space utilization information on
subareas?

The Utility manual show syntax of PRINT SPACE FOR AREA
PSDICUST.SDI-CONTRCT-AREA SUBAREA CONTRCT; but that gets a syntax error
on
the token SUBAREA, so apparently the documentation is incorrect.

Also, it seems insane to me that I would have to specify each and every
subarea. I inherited this system and had never even heard of subareas.
Now I
need to support them.

Personally, I think it's a horrible idea, since there are so many ways
to
hide problems. This all started because we started getting 1211 on store
in
an area that was 76% utilized. It took me two days to figure out it was
the
subarea concept that was screwing me up.

Any suggestions for getting out of this mess?

Buz Williams
Ateras
Dallas, TX
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: ADS question
"I think it would be an excellent ""pressie"" for us northern hemisphere
types. Still hard to visualize Christmas as a summer holiday... ;)


----- Original message -----
From: ""Cherlet, Gary (JTS)"" <Cherlet.Gary@SAUGOV.SA.GOV.AU>
To: IDMS-L@LISTSERV.IUASSN.COM
Date: Mon, 4 Dec 2006 09:52:22 +1030
Subject: Re: ADS question

I have a program that runs from enter-next-task-code prompt - you give
it the name of a dialog and it tells you what areas it uses and whether
or not the areas are available in the required usage mode - it digs
through the entrails of the dialog load module Ready Area Table and the
run-time DMCL control blocks to make this determination. It could
probably be adapted to be LINKed to from an ADS dialog - if it was
changed to workout who had LINKed down to it - then it could do the same
job except it would return some kind of status to tell you if there were
areas that were not currently available.

With Christmas coming on I could take a look at making this change and
make the program available to the IDMS listers as a ""pressie"" from down
under. If anybody is interested let me know how you would like the
interface to work - for example:

1) LINK to PGM 'XYZ' using ( area-status ).

Add rec area-status. 03 query-area pic x(16). <<< Supplied by
caller >>> 03 query-segment pic x(8). <<< Supplied by caller >>>
03 query-status pic x(3). <<< One of UPD/RET/OFF based on run-
time info in DMCL >>>

While very simple the drawback to this approach is you may need to LINK
many times if you want to check many areas

2) LINK to PGM 'XYZ' using ( dialog-area-status ).

Add rec dialog-area-status. 03 err-area pic x(16). <<<
returned >>> 03 err-segment pic x(8). <<< returned >>> 03 area-
status pic x(3). <<< One of UPD/RET/OFF based on run-time info
in DMCL >>>

The program would look through the RAT of the ""calling"" dialog (both
premap and response processes) and return the name of the ""first""
segment.area that is not available in the required usage mode. If all
areas are available the area-status would be set to 'AOK' (for example).

3) Other suggestions - for example pass a list of area names in scratch
and we could return the current run-time status of each area (similar
to Chris's suggestion of using DCMT - except this would only query
the nominated areas). This would not need to look through the RAT -
just the DMCL tables.

Add rec area-status. <<< A list of these records supplied in
Scratch - the Scratch area name passed in LINK record >>> 03 query-
segment pic x(8). <<< Supplied by caller >>> 03 query-area pic
x(16). <<< Supplied by caller >>> 03 query-status pic x(3).
<<< Supplied by caller - status being queried UPD/RET/OFF>>> 03
area-status pic x(3). <<< One of UPD/RET/OFF based on run-time
info in DMCL >>>

Like I say - if you're interested let me know how you'd like this to
work and I'll ""have a go"" to see what can be done.

Cheers - Gary


-----Original Message----- From: IDMS Public Discussion Forum
[mailTo:IDMS-
L@LISTSERV.IUASSN.COM] On Behalf Of Tim Gortner Sent: Saturday, 2
December 2006 2:11 To: IDMS-L@LISTSERV.IUASSN.COM Subject: ADS question

Hi:

I have an application that accesses a record in an area that is
sometimes offline for batch processing. I have tried to trap the 0966
that results from trying to CALC to that record so I can code around it
and keep our application up. I thought I could check the ERROR-STATUS
from a READY, but I have found that READY statements that are coded are
not actually executed until you execute a DML command, such as OBTAIN.
At least it appears that way when I ADS-Alive it.

Any ideas on how I can determine if an area is off-line before I try to
issue a DML command?

Thanks.

Tim Gortner Sr. Consultant - Sogeti USA LLC Iowa Department of Human
Services DDM Medical Systems and Data Warehousing
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: IDMS-L Digest - 30 Nov 2006 to 1 Dec 2006 (#2006-154)
"Hmmmmm, maybe this is it.

OK . . Here's a stupid question then:

Is there any way to filter the database input in an OLQ routine after
the DB selects have been done, i.e. so as to be able to select records
based on a value such as TODAY('G') or the results of a DATEOFF using
TODAY('G') as input . . . ?

Outcomes