ca.portal.admin

Re:DBNAME

Discussion created by ca.portal.admin on Nov 3, 2006
Does anyone have a code example of getting the DBNAME from the system? I
was thinking there was on option on the ACCEPT statement, but I can't
find it in the manuals.

I have an application that needs to know what DBNAME it is bound to. So
once again I am heading out to IDMS-L before I start writing from
scratch.

Thanks in advance.

Dan Hall
GE=3D20
Capital Solutions
Danbury, CT

T 513.217.5060
E dan.hall@ge.com
http://www.ge.com/capitalsolutions/
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Using PAV
"Hi,



One of our other government departments in now using PAV and IDMS 16.0
SP1. The manual mentions access to a logical disk extent. What is a disk
extent for the purposes of PAV access? Is it a database page or the
track or cylinder or OS file containing the database page?



Thanks



Chris Wood

Alberta Department of Energy

CANADA


"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
ESD file handling
"Hi:

It's dumb question time. SupportConnect seems to be having a problem and
need to get up some information. Does anyone know the DCB specification you
should use when allocating space for an ESD file to z/OS? These are the
product files we download from the web site. Also, there is a utility to
convert them to tape. Can anyone tell me where to download the latest
version? We currently have the old RESTORES utility.

Before you say it, yes, I know we are three years out of date on Common
Services. We stay pretty far back for QA purposes.

Any help you can give will be appreciated>

Tom Hebert
908-813-2866
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: ESD file handling
"Tom,

I had successful used these JCLs & procedures for SP4.

//*
//* ALLOCATE ELECTRONIC SOFTWARE DELIVERY DATASET
//* SPACESIZE = ((.ESD FILE SIZE * 1024) / 4096)
//IEFBR14A EXEC PGM=IEFBR14,REGION=12K
//*
//ESDFILE DD DSN=IDMS.SP4M603.ESD,
// UNIT=SYSDA,
// VOL=SER=IDMS01,
// DCB=(RECFM=U,BLKSIZE=4096),
// SPACE=(4096,(37501,10)),
// STORCLAS=SCNONSMS,
// DISP=(NEW,CATLG,DELETE)


//INIT EXEC PGM=IEHINITT
//SYSPRINT DD SYSOUT=*
//DD1 DD UNIT=TAPEE,VOL=(,RETAIN)
//SYSIN DD *
DD1 INITT SER=G0GJ4M,DISP=REWIND
/*
//*
//*------------------------------------------------------------------**
//*-------- RESTORES PROGRAM TO READ ESD INPUT ------------------**
//*-------- THE DISK DD IS THE INPUT ESD FILE ------------------**
//*------------------------------------------------------------------**
//RESTORE EXEC PGM=CAESDR,REGION=4M
//STEPLIB DD DSN=SYS2.CAI.CAILIB,DISP=SHR
//TAPE DD UNIT=TAPEE,LABEL=(1,SL,,EXPDT=98000),
// VOL=(,RETAIN,SER=G0GJ4M),DCB=TRTCH=COMP
//*
//DISK DD DSN=IDMS.SP4M603.ESD,DISP=SHR
//*
//SYSPRINT DD SYSOUT=*
//TAPEMAP EXEC TAPEMAP,T1=G0GJ4M,UNT=TAPEE


Vince Gibson
United Airlines _ WHQKT
IDMS Systems Software Support
847 700-6883 voice
847 700-4477
vincent.gibson@united.com

________________________________

From: IDMS 3rd-party providers forum on behalf of Thomas Hebert
Sent: Mon 11/6/2006 3:04 PM
To: IDMSVENDOR-L@LISTSERV.IUASSN.COM
Subject: ESD file handling



Hi:

It's dumb question time. SupportConnect seems to be having a problem and
need to get up some information. Does anyone know the DCB specification you
should use when allocating space for an ESD file to z/OS? These are the
product files we download from the web site. Also, there is a utility to
convert them to tape. Can anyone tell me where to download the latest
version? We currently have the old RESTORES utility.

Before you say it, yes, I know we are three years out of date on Common
Services. We stay pretty far back for QA purposes.

Any help you can give will be appreciated>

Tom Hebert
908-813-2866
"
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/SQL Default index on dbkey
"Luc,

You cannot drop the default index (the software won't let you) until you
have defined an additional index or a CALC key.

We usually drop the default indexes. A situation where you might want
to keep the default index is where you have defined a CALC key but no
other indexes, and you have only a few rows for this table in a large
area. In this case, the default index will allow you to obtain all rows
in the table without doing an area sweep.

Outcomes