Informix

 View Only

  • 1.  Load progress - raw tables

    Posted Wed May 08, 2024 04:15 PM

    I used to know this, but I'm getting old....whilst loading a raw table how can I watch the progress re: num rows? onstat -g pqs doesn't help, nor does select count(*), etc. I know why the normal methods don't work internally - just wondered if anyone else remembers how? 


    Thanks! 
    Mark



    ------------------------------
    Thanks! 
    Mark Scranton
    The Mark Scranton Group
    mark@markscranton.com
    ------------------------------


  • 2.  RE: Load progress - raw tables

    Posted Thu May 09, 2024 05:47 AM
    Edited by Doug Lawry Thu May 09, 2024 05:47 AM

    Hi Mark.

    This should do it:

    onstat -g lap

    https://www.ibm.com/docs/en/informix-servers/14.10?topic=ogmo-onstat-g-lap-command-print-light-appends-status-information

    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------



  • 3.  RE: Load progress - raw tables

    IBM Champion
    Posted Fri May 10, 2024 09:23 AM

    I might be getting old, or otherwise confused, but ...

    • why would "select count(*)" not work and return the correct current number of rows for a raw table?
    • what's the relation between raw table and light appends?

    If, on the other hand, we're talking light appends, then would 'raw' in "raw table" even be relevant?



    ------------------------------
    Andreas Legner
    ------------------------------

    Original Message


  • 4.  RE: Load progress - raw tables

    IBM Champion
    Posted Fri May 10, 2024 09:57 AM

    It's not the raw table itself but getting the count while it is being loaded in express mode to check on the progress.  The count will not reflect the "new" records until the load has completed.  At least I think that's what Mark was looking for.



    ------------------------------
    Mike Walker
    xDB Systems, Inc
    www.xdbsystems.com
    ------------------------------

    Original Message


  • 5.  RE: Load progress - raw tables

    IBM Champion
    Posted Fri May 10, 2024 10:19 AM

    Hi Mike,

    yup, with "express mode" or "light append" it makes more sense, I didn't guess that from the initial question.

    But now, why would I choose raw table for express load?  Or was the raw table already present and is now being express-loaded?
    Actually, just out of curiosity, what difference would 'express' make, over 'deluxe', with a non-logging table?

    BR,

     Andreas



    ------------------------------
    Andreas Legner
    ------------------------------

    Original Message


  • 6.  RE: Load progress - raw tables

    IBM Champion
    Posted Fri May 10, 2024 10:59 AM

    Express loads only work for raw tables in a logged database.  You could force deluxe on a raw table I expect but you won't get the performance benefit of the light appends.



    ------------------------------
    Mike Walker
    xDB Systems, Inc
    www.xdbsystems.com
    ------------------------------

    Original Message


  • 7.  RE: Load progress - raw tables

    Posted Tue May 21, 2024 09:17 AM
    Edited by Mark Scranton Tue May 21, 2024 09:18 AM

    Agreed Mike. 

    A tip for all ... if you create the table raw but it's created with ROWIDs (enforced by an index of course), EXPRESS will get changed to DELUXE (it has to) and fortunately that's reported in the msg log. My current site uses ROWIDs everywhere (yeah - ugh) and I tend to forget so watching the msg log is helpful. You usually know anyway due to load rates being so slow or just overall time of a load being much longer than expected. 



    ------------------------------
    Thanks! 
    Mark Scranton
    The Mark Scranton Group
    mark@markscranton.com
    ------------------------------

    Original Message


  • 8.  RE: Load progress - raw tables

    IBM Champion
    Posted Tue May 21, 2024 09:32 AM

    Also FYI we found that you cannot use express mode to load a table where the row size was > 4065 bytes (this was on AIX with its 4K page size).



    ------------------------------
    Mike Walker
    xDB Systems, Inc
    www.xdbsystems.com
    ------------------------------

    Original Message


  • 9.  RE: Load progress - raw tables

    Posted Tue May 21, 2024 09:13 AM

    That's the one Doug! Yes - as I said, I knew it was in my head somewhere. Apparently it wasn't a "foreground thread" ...(that was lame). Used to use "lap" all the time w/ XPS and other related stuff. 

    Thanks though - appreciate it! 

    Mark



    ------------------------------
    Thanks! 
    Mark Scranton
    The Mark Scranton Group
    mark@markscranton.com
    ------------------------------

    Original Message