IDMS

  • 1.  Question about PMSMFEX

    Posted Aug 01, 2005 11:29 AM
    I am experimenting with writing our PMAM records to SMF instead of to
    the IDMS log, for performance reasons. My question is about PMSMFEX,
    the CA-supplied Culprit program that archives the performance monitor
    records from the SMF file. PMSMFEX is working as advertised - my
    SMF-derived reports look identical to the ones derived from the log.
    But PMSMFEX runs for hours each night, and requires 10 or more scratch
    tapes for the Culprit SYS008 file. Is this normal? Is there any to
    speed it up?

    Kay Rozeboom
    State of Iowa
    Information Technology Enterprise
    Department of Administrative Services
    Telephone: 515.281.6139 Fax: 515.281.6137
    Email: Kay.Rozeboom@Iowa.Gov

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








    Normal

    Normal
    Re: EFB Abend in IDMS Startup Module After Microcode Upgrade
    "Hello Roger,

    You mentioned a micro-code upgrade. Would you be able to tell us the machine
    type, microcode level, and operating system release you are running?


    Regards,
    Neal Kostanski

    Transaction Oriented Platforms - Large Server Support
    Abbott Laboratories
    Ph: 614-624-3613 FAX: 614-727-3613
    Yahoo IM: criterion_0

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








    Normal

    Normal
    VTERM/VTAM
    "Hello,

    I have been asked to post this by my supervisor. Thanks for your
    indulgence.

    ""is anyone running VTERM/VTAM under IDMS, say setting up multiple logical
    sessions
    to access VM & VSE""

    Fred

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








    Normal

    Normal
    Re: VTERM/VTAM
    """Hill, Fred"" <fhill@SFWATER.ORG> wrote:
    ""is anyone running VTERM/VTAM under IDMS, say setting up multiple
    logical sessions to access VM & VSE""

    Hi Fred -

    We never ran VTERM but I can tell you what we DID run - BIM-WNDOW from
    Ben Moyle. It was very easy to set up and use and, as you might guess
    if you have any other of Ben's products, the support was excellent.
    Since BIM's acquisition by CSI in 2002 after Ben's death, I have no
    reason to believe that any of this has changed as the BIM employees
    themselves interviewed all the prospective buyers and chose CSI
    themselves, and those I am still in touch with today appear to be happy
    with everything.

    Here's a link to the documentation, FWIW:

    ftp://bimsrvic.bimoyle.com/download/Product-Manuals/CSI-WNDOW/Wndow%204.
    5.pdf

    Hope this is helpful.

    Mike

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








    Normal

    Normal
    Reloading data to a sorted set
    "Hello List,

    I have a question dealing with the mass loading of records.

    We will be extracting all of the member records from a sorted set. (sort
    seq. DSC by store date duplicates first) After our Database group
    initializes and resizes our area. We will then be re-storing a portion of
    the member records. We are trying to figure out the most efficient way to
    reload the data.

    <<...OLE_Obj...>>

    We are currently planning to unload the member records oldest to newest for
    each of the owner records. One idea we had was to ask our DBA staff to
    create a temporary subschema for the load of these records so that the
    member record would be stored first as shown below. Thinking that IDMS
    would have to do less work if it didn't have to maintain the sorted set.

    <<...OLE_Obj...>>

    So, our first question is does this idea have any merit? Secondly we would
    ask if this is not the best way to go about unloading and reloading this
    data while maintaining the sequence of the records how should we be
    attacking it?

    Thanks,

    Scott Van Der Heyden
    State of Iowa
    Dept. Of Human Services

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








    Normal

    Normal
    Re: Reloading data to a sorted set
    "Either
    Extract the members with the owner DBkey.
    Extract the Owners with their DBkey.
    Match owner and member records and add CALC key to Member record file.
    or
    In one program
    Read each owner extract to one file,
    Read all members for each owner extract to another file and store
    with CALC key.

    Then

    Initialize the area and resize it.
    Using IDMSCALC, calculate the new dbkey for the owners both for the owner
    file and the member file.
    Sort the two files by the calculated DBkey.
    Load the owners.
    Load the members. Remember to obtain CALC for each new owner to get them
    connected correctly.

    You can merge the two files and store the owners then the members for each
    owner, all you need is to identify the record type.

    By loading all the owners first then the members you reduce the amount of
    CALC overflows, but increase the amount of via overflows. In either case
    you will probably get about the same impact on performance.

    Not knowing how many member records you are getting rid of, I would suggest
    that you consider deleting the members you don't want. Then run an
    unload/reload to resize the area afterwards.

    Tommy Petersen




    Scott Van Der
    Heyden
    <svander@DHS.STAT To
    E.IA.US> IDMS-L@LISTSERV.IUASSN.COM
    Sent by: IDMS cc
    Public Discussion
    Forum Subject
    <IDMS-L@LISTSERV. Reloading data to a sorted set
    IUASSN.COM>


    08/05/2005 01:02
    PM


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






    Hello List,

    I have a question dealing with the mass loading of records.

    We will be extracting all of the member records from a sorted set. (sort
    seq. DSC by store date duplicates first) After our Database group
    initializes and resizes our area. We will then be re-storing a portion of
    the member records. We are trying to figure out the most efficient way to
    reload the data.

    <<...OLE_Obj...>>

    We are currently planning to unload the member records oldest to newest for
    each of the owner records. One idea we had was to ask our DBA staff to
    create a temporary subschema for the load of these records so that the
    member record would be stored first as shown below. Thinking that IDMS
    would have to do less work if it didn't have to maintain the sorted set.

    <<...OLE_Obj...>>

    So, our first question is does this idea have any merit? Secondly we
    would
    ask if this is not the best way to go about unloading and reloading this
    data while maintaining the sequence of the records how should we be
    attacking it?

    Thanks,

    Scott Van Der Heyden
    State of Iowa
    Dept. Of Human Services

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








    Normal

    Normal
    Re: Reloading data to a sorted set
    "I would suggest you think about a user-owned index instead of a sorted
    set for efficiency reasons.

    Dan Miley
    Lockheed Martin