Informix

nested-group-icon.png

DB2

Expand all | Collapse all

Spot the difference

  • 1.  Spot the difference

    Posted 24 days ago

    > onstat -

    IBM Informix Dynamic Server Version 14.10.FC4W1DE -- On-Line -- Up 10 days 04:18:20 -- 334828 Kbytes

    >

    > onstat -

    IBM Informix Dynamic Server Version 14.10.FC5DE -- On-Line -- Up 00:01:54 -- 185996 Kbytes
    2020-12-22 18:08:01

    >

    Is this feature or bug?

    Hrvoje



    ------------------------------
    Hrvoje Zokovic
    ------------------------------


  • 2.  RE: Spot the difference

    Posted 24 days ago

    It is feature

    From xC5 onwards, the header also includes a datetime stamp in the format: <year>-<month>-<day> <hour>:<minute>:<second>

    IBM Informix Dynamic Server Version 14.10.FC5 -- On-Line -- Up 00:00:22 -- 54180 Kbytes
    2020-12-17 19:15:15


    ------------------------------
    Hrvoje Zokovic
    ------------------------------



  • 3.  RE: Spot the difference

    Posted 23 days ago
    Edited by SangGyu Jeong 23 days ago

    I also installed 14.10.fc5 to see this change.

    It is nice to be able to leave a timestamp without a command like date in the onstat result. :)

    https://www.ibm.com/support/knowledgecenter/SSGU8G_14.1.0/com.ibm.adref.doc/ids_adr_0495.htm

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------



  • 4.  RE: Spot the difference

    Posted 23 days ago
    I created a case and IBM engineer told me this is a new feature in xC5.

    I don't understand the reason to do this, but it seams this new timestamps is going to stay even it broke most of our parsing shells :-(

    Vicente Salvador






  • 5.  RE: Spot the difference

    Posted 23 days ago

    That was my initial thought. I like the feature, but that's going to break a bunch of scripts out there. [Thankfully I don't think any of mine are impacted; our scripts only ever run onstat - to check the return code, and other onstat scripts are already parsed with grep and similar to look for specific things.]



    ------------------------------
    TOM GIRSCH
    ------------------------------



  • 6.  RE: Spot the difference

    Posted 23 days ago
    A bit like  the recent DBINFO change that broke lots of scripts.

    Cheers
    Paul

    Paul Watson
    Oninit LLC
    +1-913-387-7529
    www.oninit.com
    Oninit®️ is a registered trademark of Oninit LLC





  • 7.  RE: Spot the difference

    Posted 23 days ago

    Hi Paul.

    > A bit like  the recent DBINFO change that broke lots of scripts.

    I must have missed that one.  What change was made to DBINFO? I'm not that heavy a user thereof but I wouldn't mind being forewarned.



    ------------------------------
    Jacob Salomon
    ---
    Nobody goes there anymore, it's too crowded.  --Attr: Yogi Berra
    ------------------------------



  • 8.  RE: Spot the difference

    Posted 23 days ago

    IIRC correctly, it isn't DBINFO itself that changed, but rather the system catalogs. They created some new entries with partnum values below 1048576. So if you don't filter those out, DBINFO('dbspace',partnum) will throw an error, saying that it can't decode the partnum value.

     






  • 9.  RE: Spot the difference

    Posted 22 days ago
    Thanks Tom.

    My old scripts, pre-dating the "dbspace" option for dbinfo (or at least my knowledge thereof) use mod(partnum, 1048576) joined to sysdbspaces.dbsnum so my queries would have skipped such pseudo-partitions.

    But nice to be aware of the issue.

    - Jacob S





  • 10.  RE: Spot the difference

    Posted 17 days ago
    Yes Vincente, I agree. IMHO this feature should not be default - it can be turned on e.g. with env variable.
    Informix was known for consistency with older versions and new features (almost all) can be turned on with oncofig settings or env variable.
    Hrvoje