admin

Just another wannabee. I make tech-stuff work (a lot of Oracle)

sar usage

I like to use the linux utility sar (system activity reporter (?)) I gives a fast and quite complete overview over the performance of a linux system. SAR has a lot of possibilitys. I just highlight a few of them to remember how the syntax is 🙂 CPU information of today oracle@lqas4342:~$sar Linux 4.18.0-425.13.1.el8_7.x86_64 (lqas4342.mod.nl) …

DB2 Row generator

Sometimes you need a mechanism to generate rows. For example when you need to create a demonstration table . Recursive CTE’s (Common Table Expression) might be your friend   WITH engine (rownum) AS (select 1 as rownum from sysibm.sysdummy1 union all select rownum + 1 AS rownum from engine where rownum<10) SELECT rownum FROM engine; …