Load progress - raw tables

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 ------------------------------

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 ------------------------------

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 ------------------------------

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 ------------------------------

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 ------------------------------

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 ------------------------------

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 ------------------------------

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 ------------------------------

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 ------------------------------