ca.portal.admin

SQL Option overhead

Discussion created by ca.portal.admin on Mar 7, 2007
Latest reply on Mar 9, 2007 by ca.portal.admin
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%2Eimrworldwi
de%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801577%2Fpi%5F100
5244%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: [IDMSVENDOR-L] PEA Regarding Broken Chains
"is it known if this problem exists only in the CV mode world? or could it
exist in then batch world as well (when buffers were gt 2048 pages?)



This is Chris Hoelscher and I approved this message!

Chris Hoelscher
Senior 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
Re: PEA Regarding Broken Chains
"If
Here is the scoop on the problems QO84981 and QO84982 are creating:

If you have this APAR on and you have buffer pools with more than 2048 pages and that buffer pool has areas in update you will corrupt your database. When a page in the buffer pool is updated the must write flag is set on the buffer page. When the run unit ends, pages with the must write flag are written to disk. This APAR has corrupted the buffer bit map and pages past 2048 are not being written to disk. When you shut down the CV, the update is lost for good. On a positive note, the update was journaled and is on the journal. The work around is to vary all of the update areas to retrieval and run a program that area sweeps an area mapped to the affected buffer. This forces the pages with the must write flag set to be flushed and written to disk. Once you get all of the pages written to disk you can either vary the buffers down to less than 2048 and stop the problem. You could also cycle the CV and back APAR off. If for some reason you decide to leave the APAR on, you need
to make sure that the buffers aren't greater than 2048 pages. CA Tech support also said that closing the buffer or varying the area would't force the missing writes to occur.

The site that I support is 15.0 and we put QO84981 on last weekend. We spent about 8 hours today making sure that all of the updated pages were written to disk. I think we caught everything, but we are not going to cycle until Friday night in case we blow a database area up. We would have to recover the database and we can't afford to do that during the week.

Mark Grindstaff


----- Original Message ----
From: Bob Wiklund <wiklund@TIBURONTECH.COM>
To: IDMS-L@LISTSERV.IUASSN.COM
Sent: Wednesday, March 7, 2007 3:58:08 PM
Subject: PEA Regarding Broken Chains


IDMS Support has posted information on apars QO84981 and QO84982 which have the potential to cause database corruption. For more information, see: http://supportconnectw.ca.com/public/idms/idms_supp.asp <http://bull.tiburontech.com/exchweb/bin/redir.asp?URL=http://supportconnectw.ca.com/public/idms/idms_supp.asp>

Bob Wiklund
Tiburon Technologies
623 594-6022
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
SQL Option overhead
"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
"Install the SQL option, it's free (nowadays), and it wont hurt. It
allows your dba's to compete for SQL work, if management does not have a
strategic directive against using IDMS in a relational way. I had used
it at another site with a Powerbuilder front end and found it more
manageable, as far as impact on other work in the cv goes, then other
DBMS's. That app was inquiry only, and used by buyers to make seasonal
buying decisions; a homebuild wharehousing app without all the
mumbojumbo and banks of mostly empty dasd. The app looked at the
current inventory, without replication and overhead. I was impressed by
how easy it was to manage cv'wise. However, less impressed by the IDMS
SQL optimizer, which we could never go after records calc, and to use
the right indexes in the right combination. I understand a lot of work
has been done on the optimizer. We could have used 'hints', which is an
Oracle feature to tell the optimizer to do what it's told by the dba,
but that feature was not available at the time with IDMS SQL. I have
not had any IDMS SQL experience in the last ten years.

Lutz Petzold


-----------------------------------------
This e-mail may contain confidential or privileged information. If
you think you have received this e-mail in error, please advise the
sender by reply e-mail and then delete this e-mail immediately.
Thank you. Aetna

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








Normal

Normal
Re: QO84982 Broken Chains
"Bill,

I have looked at QO84981 and it applies to all levels of 15.0 yet
QO84982 only applies to 16.0 SP2 and above. Did something get dropped
out of 16.0 SP0 and 1 for this problem not to be present in those levels
too?

Thanks

Chris

Outcomes