CA IDMS IUA EIUA

Expand all | Collapse all

Bogus User Set Error from DB AUDIT

  • 1.  Bogus User Set Error from DB AUDIT

    Posted 11-02-2006 05:31 AM
    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
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    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 dan.hall@ge.com
    http://www.ge.com/capitalsolutions/


  • 2.  Re:Bogus User Set Error from DB AUDIT

    Posted 11-02-2006 05:31 AM
    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
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    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
    gene.verinder@alliancedata.com


  • 3.  Re: Bogus User Set Error from DB AUDIT

    Posted 11-02-2006 05:38 AM
    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
    Dan.Hall@GE.COM 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
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    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
    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: 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
    Linda.Campbell@INFORMATIXINC.COM 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
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP








    Normal

    Normal
    Re: SP4
    "Hi Steve,

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


  • 4.  Re: Bogus User Set Error from DB AUDIT

    Posted 11-02-2006 06:18 AM
    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>>>
    Dan.Hall@GE.COM 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
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    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
    Dan.Hall@GE.COM 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
    IDMS-L@LISTSERV.IUASSN.COM
    SMTP
    IDMS-L@LISTSERV.IUASSN.COM
    IDMS-L@LISTSERV.IUASSN.COM
    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