ca.portal.admin

QO84982 Broken Chains

Discussion created by ca.portal.admin on Mar 7, 2007
Latest reply on Mar 8, 2007 by ca.portal.admin
CA Have issued QI86517 stating that QO84982 can create broken chains
when using large buffer pools. No being on SP2/3/4 I cannot remember if
there is an SP0/1 version of QO84982. I could not find one.



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
QO84982 Broken Chains
"CA Have issued QI86517 stating that QO84982 can create broken chains
when using large buffer pools. No being on SP2/3/4 I cannot remember if
there is an SP0/1 version of QO84982. I could not find one.



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
Re: SQL Option overhead
"Sam,

Although my experience is about 10 years old, as far as I remember there
was no overhead running with the SQL Option, in itself.
Meaning IDMS with SQL Option performs the same as IDMS without the SQL
Option.

Naturally when you start using the SQL Option you will impact the overall
performance of the CV, just as it is with any additional workload.
Keep in mind that it is significantly easier to write really bad SQL than
it is to write really bad DML, so make sure your resource limits are set
appropriately.

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

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




Sam Mowbray
<base.data@HOTMAI
L.COM> To
Sent by: IDMS IDMS-L@LISTSERV.IUASSN.COM
Public Discussion cc
Forum
<IDMS-L@LISTSERV. Subject
IUASSN.COM> SQL Option overhead


03/07/2007 08:04
PM


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






Hi List,

I am currently investigating the SQL Option and am interested to find out
different sites experiences with the option and the overhead in terms of
CPU
that you may have experienced.

Regards

Sam Mowbray
Total Data Design Pty Ltd

_________________________________________________________________
AdvertisemSent: It's simple! Sell your car for just $20 at carsales.com.au
http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801577%2Fpi%5F1005244%2Fai%5F838588&_t=757768878&_r=endtext_simple&_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
Re: SQL Option overhead
"Sam, can you be more specific with your question?

Also, do you plan to use the SQL option To: a) access network database
via SQL, or b) create new relational databases?

The short answer is that, in my experience, a relational database (of
any brand) will never perform as well as a network database. But there
can be valid reasons for going relational in spite of the performance
cost.

Outcomes