ca.portal.admin

Perfmon SMF 230 Records

Discussion created by ca.portal.admin on Nov 8, 2006
I have just noticed that my 16.0 SP4 CV's are not cutting SMF 230 records.
I have reviewed the #PMOPT module, everything looks OK, same as our 15.0
which works. Anybody else seen a problem with this?

Thanks,
Steve Harmeson
"
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,

For the performance issue: Make sure the largest row length is less than
30% of the page size.
For your deadlocks: If the index is on the dbkey or any other sequentially
assigned value (timestamp or sequence number), all inserts will target the
same index block and increase the risk of deadlocks, you will need to find
a way of single threading the inserts, or change the index to be on a
column that does not have a sequentially assigned value.

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

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




Luc De Naeyer
<Luc.Denaeyer@INF
OCO.BE> To
Sent by: IDMS IDMS-L@LISTSERV.IUASSN.COM
Public Discussion cc
Forum
<IDMS-L@LISTSERV. Subject
IUASSN.COM> Re: IDMS/SQL Default index on dbkey


11/08/2006 08:22
AM


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






Kay,

You can always drop the default index. Even when there are no additional
indexes or CALC key. You get then a 'direct' table.
Insert in a table without calc, index or default index means that IDMS will
start at the beginning of the area and search forward.(Exception for BULK
insert). There is nothing like a direct-dbkey.
We have created a table without calc, index or default index (estimated
rows
600.000), and the result is a very bad performance. (Insert).
When I recreate the table with a default index only, we have a locking
problem in de default index.
I think I have to recreate the table with a 'dummy-value' calc key
(Sequence
number).
Other solutions are welcome,

Luc


----- Original Message -----
From: ""Rozeboom, Kay [DAS]"" <KAY.ROZEBOOM@IOWA.GOV>
To: <IDMS-L@listserv.iuassn.com>
Sent: dinsdag 7 november 2006 14:25
Subject: 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.


-----Original Message-----
From: IDMS Public Discussion Forum [mailTo:IDMS-L@LISTSERV.IUASSN.COM]
On Behalf Of Luc De Naeyer
Sent: Tuesday, November 07, 2006 2:28 AM
To: IDMS-L@LISTSERV.IUASSN.COM
Subject: IDMS/SQL Default index on dbkey

When a table has been created there is always a default index on dbkey.
Who has some experience with this default index? When can this index be
dropped, or when not?

Thanks,
Luc

Luc De Naeyer
Infoco (InformaticsColruyt)
T : +32 2 360 10 40
Luc.Denaeyer@infoco.be
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: SMF perfmon problem
"Hey Steve your childhood neighbor here.....

maybe the SVCOPT SMF parm? The default is NO.

Rob


Rob Klan/Cincinnati/IBM
Phone: 1-877-205-4871 (T/L: 349-2446)
ITN: 23492446
Email: rklan@us.ibm.com



""Harmeson, Steve"" <Steve.Harmeson@NGC.COM>
Sent by: IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>
11/10/2006 06:17 AM
Please respond to
IDMS Public Discussion Forum <IDMS-L@LISTSERV.IUASSN.COM>


To
IDMS-L@LISTSERV.IUASSN.COM
cc

Subject
Re: SMF perfmon problem






Hi John,

Thanks for the reply. I checked the sysgen and yes I have TASK COLLECT
specified. I checked my #PMOPT member in PPOPTIONS
and this is the values:
#PMOPT ,
AMACT=YES,
AMDCLOG=NO,
AMSMF=YES,
AMSMFSZ=8180,
DCSTATS=NO,
IMACT=NO,
IMDCLOG=NO,
IMSMF=NO,
SMFRCID=230
END

So by everything I see it should be cutting smf 230 rec's.

Thanks,
Steve

Outcomes