Bogus User Set Error from DB AUDIT

[ca.portal.admin]

We are at release 12.01 (9809) and getting a b=

Hail, Listers:=0D=0A=20=0D=0AWe are at release 12.01 (9809) and getting
a b= ogus user set error in DB AUDIT. The audit shows no pointer
errors; but, 1= user set with 70 out of sequence sort keys. I've
checked the set in quest= ion using DMLO (thankfully, it's quite short)
and there is no problem with = the sequence. Do you all know of this
being a problem with DB AUDIT=3F Is= there something I'm missing that
could account for what appears to be a re= d herring output from the
audit=3F=0D=0A=20=0D=0AThanks,=0D=0A=20=0D=0ARoge=
r C. Lawrence=0D=0ADatabase Administrator=0D=0ASeminole Electric
Cooperativ= e, Inc.=0D=0ATampa, Fl.=0D=0A813.739.1518=0D=0A=0D=0A_ _ _ _
_ _ _ _ _ _ _ = _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _=0D=0A=0D=
=0A** NOTICE **=0D=0AThis e-mail message, including any attachments, is
for= the sole use of the intended=20=0D=0Arecipient(s) and may contain
confiden= tial, proprietary and privileged information.=20=0D=0AAny
un-authorized rev= iew, copying, use, disclosure, or distribution is
prohibited.=20=0D=0AIf yo= u are not the intended recipient, please
contact the sender by reply e-mail= and=20=0D=0Adestroy all copies of
the original message.=0D=0A_ _ _ _ _ _ _= _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ = _ _ _=0D=0A
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: Bogus User Set Error from DB AUDIT
"
Resending, not sure if it went to IDMS-L or only IDMSVENDOR-L.


Roger,
Do you have any FILLER in the sort keys? If so, is it consistent? All
spaces, all low values, etc...? Are you using the exact same
DMCL/SCHEMA/SUBSCHEMA combination in both DB AUDIT and DMLO?

These are the only things I can think of at this time of the
morning...=20


Dan Hall
GE=20
Capital Solutions
Danbury, CT

T 513.217.5060
E [e-mail]
http://www.ge.com/capitalsolutions/

[ca.portal.admin]

We are at release 12.01 (9809) and getting a b=3D

Hail, Listers:=3D0D=3D0A=3D20=3D0D=3D0AWe are at release 12.01 (9809) =
and getting a b=3D ogus user set error in DB AUDIT. The audit shows no
pointer errors; but, 1=3D user set with 70 out of sequence sort keys.
I've checked the set in quest=3D ion using DMLO (thankfully, it's quite
=
short)
and there is no problem with =3D the sequence. Do you all know of this
being a problem with DB AUDIT=3D3F Is=3D there something I'm missing =
that could account for what appears to be a re=3D d herring output from
the
audit=3D3F=3D0D=3D0A=3D20=3D0D=3D0AThanks,=3D0D=3D0A=3D20=3D0D=3D0ARoge=
3D=

r C. Lawrence=3D0D=3D0ADatabase Administrator=3D0D=3D0ASeminole Electric
Cooperativ=3D e, Inc.=3D0D=3D0ATampa, =
Fl.=3D0D=3D0A813.739.1518=3D0D=3D0A=3D0D=3D0A_ _ _ _ _ _ _ _ _ _ _ =3D _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ = _ _ _ _ _ _ _ _
_=3D0D=3D0A=3D0D=3D
=3D0A** NOTICE **=3D0D=3D0AThis e-mail message, including any =
attachments, is for=3D the sole use of the
intended=3D20=3D0D=3D0Arecipient(s) and may = contain confiden=3D tial,
proprietary and privileged = information.=3D20=3D0D=3D0AAny
un-authorized rev=3D iew, copying, use, disclosure, or distribution is
prohibited.=3D20=3D0D=3D0AIf yo=3D u are not the intended recipient, =
please contact the sender by reply e-mail=3D and=3D20=3D0D=3D0Adestroy
all = copies of the original message.=3D0D=3D0A_ _ _ _ _ _ _=3D _ _ _ _
_ _ _ _ _ _ _ _ = _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ =3D
_ _ _=3D0D=3D0A
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: SP4
"Rene,

I would also be very interested in knowing if anyone has had any bad experiences with SP4. We are scheduled to migrate production to it in February from 14.1 SP3. Since the website is still down, searching the archives is not available so maybe someone would like to share any experiences.

Thanks,

Gene Verinder
Database Support
Alliance Data
[e-mail]

[ca.portal.admin]

The point is: there are no records out of sort sequence.
Dan,

The point is: there are no records out of sort sequence. The set order
checks out fine in DMLO; but, DB AUDIT says there is an out-of-sequence
problem for the set.

Thanks,

Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518

[e-mail] 11/02/06 12:54 PM >>>

Roger,
The only other thought would be if you all the numeric fields in the
sort keys handle signs the same way. Are all of them unsigned or all
signed? Could someone have filled in the fields with the opposite sign?
In dmlo look at one of the records that is out of the sort sequence that
it should be in. Change the display to hex and look at the hex values.

Good luck. Been there, bought the t-shirt.


Dan Hall


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _

** NOTICE **
This e-mail message, including any attachments, is for the sole use of
the intended
recipient(s) and may contain confidential, proprietary and privileged
information.
Any un-authorized review, copying, use, disclosure, or distribution is
prohibited.
If you are not the intended recipient, please contact the sender by
reply e-mail and
destroy all copies of the original message.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
former CA CEO gets jail time
"http://money.cnn.com/2006/11/02/news/newsmakers/kumar.reut/



CA's ex-CEO gets 12 years for fraud
Sanjay Kumar also fined $8 million for his role in $2.2 billion accounting
fraud at software company.
November 2 2006: 1:01 PM EST

NEW YORK (Reuters) -- Sanjay Kumar, the former chief executive of CA, was
sentenced to 12 years in federal prison Thursday for his role in a $2.2
billion accounting fraud at the computer software company.
U.S. Judge Leo Glasser also fined the former executive $8 million. Kumar's
surrender date was set for Feb. 27.
He was also given three years of supervised release for each of eight
counts to which he pleaded guilty.
Kumar, 44, pleaded guilty to charges including conspiracy, securities
fraud and obstruction of justice in federal court in Brooklyn in April.
As part of the accounting scheme, Kumar improperly booked software license
revenue from 1999 to 2000 in order to meet Wall Street analysts' profit
expectations and then lied to investigators about it, the government said.
Assistant U.S. Attorney Eric Komitee told the judge that Kumar's actions
represented ""the most brazen and comprehensive obstruction in the modern
era of corporate crime.""
His lawyers asked for leniency, citing Kumar's good works.
""This is not a case where the fraud affected the fundamental health of the
company,"" said defense attorney Robert Fiske. ""CA is still a thriving
company.""
CA, previously known as Computer Associates International, restated its
results for fiscal years 2001 through 2004 after Kumar left the company in
2004.
The company agreed to pay $225 million in shareholder restitution and
continues to cooperate with the government as part of a deferred
prosecution agreement.
CA competes in the corporate software industry with BMC Software (Charts)
EMC (Charts) and IBM (Charts).
Shares of CA (up $0.32 to $25.02, Charts) rose 1.9 percent in afternoon
trade Thursday.



Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[e-mail]




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
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: Bogus User Set Error from DB AUDIT
"The sort key comprises two elements, both of which are
Linda,

The sort key comprises two elements, both of which are unsigned numeric (9(03) and 9(04)) display. Also, the set is a sorted (non-index) set. I'm about ready to call this a utility-related fluke. The database is OK; that's what matters, right?

Thanks,

Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518

[e-mail] 11/02/06 2:01 PM >>>

Roger,

There was a problem in IDMS where some utilities would flag an index as
out of sequence and some would not. The sequencing issue had to do with
signed comp-3 fields and the handling of the signs under certain
specific circumstances. If you were just looking at the records, they
would look like they were in the correct order because the field that
was signed wasn't something that really should have been (in our case it
was a date). You didn't say if these were sorted or indexed sets. I
don't think this problem affects sorted sets. A hyper apar was issued
to fix this bug and required that the affected indexes be rebuilt. This
may not be your situation, but thought you should know. The point is
that all utilities do not handle all data in exactly the same way.

Linda Campbell
Informatix Inc



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

** NOTICE **
This e-mail message, including any attachments, is for the sole use of the intended
recipient(s) and may contain confidential, proprietary and privileged information.
Any un-authorized review, copying, use, disclosure, or distribution is prohibited.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: SP4
"Hi Steve,

What in particular were the challenges for you for the INTC/CINT changes?

[ca.portal.admin]

No filler in the keys. Key values are consistently comp=

Dan,=0D=0A=20=0D=0ANo filler in the keys. Key values are consistently
comp= lete on all member records. I have verified (even punched
subschema to loa= d library again to be certain) that the subschema,
DMCL are the same.=0D=0A= =20=0D=0AThanks,=0D=0A=20=0D=0ARoger C.
Lawrence=0D=0ADatabase Administrato= r=0D=0ASeminole Electric
Cooperative, Inc.=0D=0ATampa, Fl.=0D=0A813.739.151= 8=0D=0A=0D=0A>>>
[e-mail] 11/02/06 10:38 AM >>>=0D=0A=0D=0ARoger,=0D= =0ADo you
have any FILLER in the sort keys=3F If so, is it consistent=3F Al=
l=0D=0Aspaces, all low values, etc...=3F Are you using the exact
same=0D=0A= DMCL/SCHEMA/SUBSCHEMA combination in both DB AUDIT and
DMLO=3F=0D=0A=0D=0AT= hese are the only things I can think of at this
time of the morning...=20=0D= =0A=0D=0A=0D=0ADan Hall=0D=0A=0D=0A=0D=0A_
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ = _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _=0D=0A=0D=0A** N= OTICE **=0D=0AThis e-mail
message, including any attachments, is for the so= le use of the
intended=20=0D=0Arecipient(s) and may contain confidential, p=
roprietary and privileged information.=20=0D=0AAny un-authorized review,
co= pying, use, disclosure, or distribution is prohibited.=20=0D=0AIf
you are n= ot the intended recipient, please contact the sender by reply
e-mail and =0D= =0Adestroy all copies of the original message.=0D=0A_ _
_ _ _ _ _ _ _ _ _ _= _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _=0D=0A=
"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: Bogus User Set Error from DB AUDIT
"The point is: there are no records out of sort sequence.
Dan,

The point is: there are no records out of sort sequence. The set order checks out fine in DMLO; but, DB AUDIT says there is an out-of-sequence problem for the set.

Thanks,

Roger C. Lawrence
Database Administrator
Seminole Electric Cooperative, Inc.
Tampa, Fl.
813.739.1518

[e-mail] 11/02/06 12:54 PM >>>

Roger,
The only other thought would be if you all the numeric fields in the
sort keys handle signs the same way. Are all of them unsigned or all
signed? Could someone have filled in the fields with the opposite sign?
In dmlo look at one of the records that is out of the sort sequence that
it should be in. Change the display to hex and look at the hex values.

Good luck. Been there, bought the t-shirt.


Dan Hall


_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

** NOTICE **
This e-mail message, including any attachments, is for the sole use of the intended
recipient(s) and may contain confidential, proprietary and privileged information.
Any un-authorized review, copying, use, disclosure, or distribution is prohibited.
If you are not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

"
IDMS Public Discussion Forum
[e-mail]
SMTP
[e-mail]
[e-mail]
SMTP








Normal

Normal
Re: Bogus User Set Error from DB AUDIT
"Roger,

There was a problem in IDMS where some utilities would flag an index as
out of sequence and some would not. The sequencing issue had to do with
signed comp-3 fields and the handling of the signs under certain
specific circumstances. If you were just looking at the records, they
would look like they were in the correct order because the field that
was signed wasn't something that really should have been (in our case it
was a date). You didn't say if these were sorted or indexed sets. I
don't think this problem affects sorted sets. A hyper apar was issued
to fix this bug and required that the affected indexes be rebuilt. This
may not be your situation, but thought you should know. The point is
that all utilities do not handle all data in exactly the same way.

Linda Campbell
Informatix Inc