Follow me !
By PDGACO GaballaLoans
Search this blog
-
Recent posts
Tags
AIX Apple automation backup best practices Bootcamp cloud cursor db2 db2 compression db2 hadr db2 performance db2 tuning db2 v9.5 db2 v9.7 db2move db2pd google indexes install iPad iPhone linux Macbook memory NULLID Oracle package performance restore runstats script shell script sql SQL805N SQL Server stored procedure tablespace time machine tuning ubuntu ubuntu 9.04 upgrade Windows on Mac wordpressDisclaimer
The posts here are solely my personal views and opinion. Any technical advice or instructions are based on my own personal knowledge and experience, and should only be followed by an expert after a careful analysis or consultation with technical support. Please test any actions before performing them in a critical or nonrecoverable environment. Any actions taken based on my experiences should be done with extreme caution. I am not responsible for any adverse results. I do not represent any vendor or product.
Tag Archives: sql
first and last day of the month
Here is a quick way to find the first and last day of the month : with temp1 (first_day_of_month,last_day_of_month) as (values ((current date – day(current date + 1 month) days) + 1 DAY, (current date + 1 month) – day(current … Continue reading
Extracting Siebel ETL timings
For a long time, I relied on my siebel admins to get Siebel ETL timings and often struggled to get certain information. Last week, I realized why bother when all the info are available on DB2 tables. This sql gives … Continue reading
Posted in Applications, db2
Tagged db2, ETL, ETL througput, ETL tiings, siebel, siebel and db2, Siebel ETL, sql, trend analysis
Leave a comment
I know stage 1 and stage 2 predicate…whats stage 3 and 4 ??
When tuning a SQL, one of the things a DBA looks at is to see whether the predicate in the SQL is stage 1 or stage 2. So what is stage 1 and stage 2. Basically when DB2 optimizer evaluates … Continue reading
Posted in db2
Tagged database manager, db2, optimizer, performance, predicate, RDS, sql, sql tuning, stage 1, stage 2, stage 3, stage 4, tuning
Leave a comment
DB2 Command Line Processing
Yesterday, I had posted about db2batch. One of my blog reader who was pretty new DB2 asked me how to run a set of sql from a file. Thats when I realized my blog doesn’t cover newbies, so thought I … Continue reading
Posted in db2
Tagged -svtf, command editor, command line, db2, db2 clp, db2 command, db2cmd, db2profile, sql
Leave a comment