ca.portal.admin

IDMS SQL Command Alert

Discussion created by ca.portal.admin on Jan 12, 2006
Latest reply on Jan 13, 2006 by ca.portal.admin
Importance: High

IDMS SQL Users,

Is this something that a syntax checker could stop, or is there any way
to guard against this type of behavior?

One of our programmers recently issued a SELECT command in OCF with a
syntactical error that caused the task to loop. Unfortunately, the
command was issued near quitting time, so the programmer closed his
Tn3270 session and left for the day. The task finally abended when IDMS
was cycled 11 hours later. By that time it had used over 4 hours of CPU
time. We have told the application staff to be more careful. But is
there anything CA can do, or we can do to prevent this? (Besides take
away their OCF access!)


The intended command was:

SELECT *
FROM SCHEMA.OMBASEREC, SCHEMA.OMCUSTREC
WHERE CUST_OM_SEC_CODE = 'DD'
AND ""OMBASE-CUST""

The errant command left off the ""AND OMBASE-CUST"" extension.


The set is defined as:

SET NAME IS OMBASE-CUST
ORDER IS SORTED
MODE IS CHAIN LINKED TO PRIOR
OWNER IS OMBASEREC
*+           WITHIN AREA OMBASE-AREA
NEXT DBKEY POSITION IS 10
PRIOR DBKEY POSITION IS 11
MEMBER IS OMCUSTREC
*+           WITHIN AREA OMINCI-AREA
NEXT DBKEY POSITION IS 1
PRIOR DBKEY POSITION IS 2
LINKED TO OWNER
OWNER DBKEY POSITION IS 3
MANDATORY AUTOMATIC
KEY IS (
CUST-OM-DATE-GROUP DESCENDING )
DUPLICATES ARE FIRST
NATURAL SEQUENCE
.










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








Normal

Normal
Recall: IDMS SQL Command Alert
"Bugger, Elaine C EALT would like to recall the message, ""IDMS SQL Command Alert"".

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








Normal

Normal
!!!! IUA Workshop 2006 !!!!
"Ladies and gentlemen,

The IUA proudly announces the dates and location for the 2006
IUA workshop;

*********************************

Dates: April 10-12

Location: CA Offices in Dallas, Texas
(semi-conveniently located 25 minutes from DFW airport)
5465 Legacy Drive
Plano, TX 75024-3106


********************************

We are extremely excited about this year's event. We will be presenting
four tracks of valuable education for DBA's and programmers alike.
Included
in this years curriculum will be classes on CA-IDMS technical topics and

classes that will expand your horizons such as web access and
web applications.

The workshop is priced at a very reasonable $199 per attendee.
Your registration covers continental breakfast Monday-Wednesday and
lunch on Monday and Tuesday. The Computer Associates hotel rates in
the area very reasonable as you can see from the list of recommended
hotels
below. You will need to ask for the CA rate when making reservations.

The area around the CA offices offers one of Texas largest malls,
movie theaters, a wide variety of dining experiences, and the fun of
Dave and Busters bar and arcade.

Web registration and a list of classes offered will be available in a
few weeks.
If you have any burning questions you can email one of our conference
co-chairs Bob Wiklund at Bob_Wiklund@Tiburontech.com.

See you in Dallas !

Terry Schwartz
(Perot Systems)
IUA National Chair




Local Hotels

AmeriSuites
3100 Dallas Parkway
Plano, TX
(972) 378-3997
CA Preferred Rate: $75
Complimentary Shuttle Service
Approx: 4.5 miles Courtyard Plano Legacy Park
6840 N. Dallas Tollway
Plano, TX
(972) 403-0802
CA Preferred Rate: $95
Complimentary Shuttle Service
Approx: 2.3 miles

Hampton Inn & Suites
3199 Parkwood Boulevard
Frisco, TX
(972) 712-8400
CA Preferred Rate: $89
Complimentary Shuttle Service
Approx: 2.5 miles Residence Inn Plano
5001 Whitestone Lane
Plano, TX
(972) 473-6761
CA Preferred Rate: $95
Complimentary Shuttle Service
Approx: 2.8 miles

Homewood Suites by Hilton
4705 Old Shepard Place
Plano, TX
(972) 758-8800
CA Preferred Rate: $94
Complimentary Shuttle Service
Approx: 5.6 miles Hampton Inn Plano
4901 Old Shepard Road
Plano, TX
(972) 519-1000
CA Preferred Rate: $69
Complimentary Shuttle Service
Approx: 5.7 miles


"
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 Command Alert
"We put pretty strict limits on OCF. If someone needs to do a very large
query, they can run it in local mode using BCF. We also have a special
""query-only"" CV with the database files in retrieval mode, where the
limits are set higher for larger queries. Either of these solutions
will allow people to do large queries with minimal impact to the OLTP
CV's.

Outcomes