About: Renu Sharma
• Over 20 years of experience in IT industry. Worked on various hardware areas including ES9000, IBM 390, IBM 370, RS 6000, AS/400, AIX, Solaris, Unix, HP Unix, Windows 2000 Server, Professional and Millennium edition and software areas including UDB DB2, DB2, Oracle, CICS, UNIX, UNIFY, JAVA, EJB and COBOL.
• Has extensive experience in Data Base Administration, data modeling, analysis, design and development in mainframe and Client Server. Has worked as Data Base Administrator, DWA on UDB 6.x, 7.x AND 8.x.
• Has 8 yrs+ experience as UDB DBA, Developer, FDA and DWA.
• More than 4 yrs of Data modeling using ERWIN, Designer 2000.
• 3 Yrs of Mainframe COBOL, DB2 and CICS Developer.
• Has been 6 Yrs on UNIX as Administrator and COBOL developer.
• Experience in all phases of Software Development Life Cycle.
• Acted as consultant to large projects involving debugging of code written in COBOL, COBOL II, DB2, UDB DB2 (LUW), Oracle and Software Installation.
Recent Posts by Renu Sharma
Today’s Blog is about one of the ACE DBA’s products. The first one is ACECOMPDDL, which compares the DDL of two databases, schemas and objects on db2 udb LUW databases. I remember why I had to create this utility , at a client’s place I had Q replication set up
more
Good Bye DB2’s got Talent
So march 15 th was my last presentation as I was in bottom three and Judges chose Ember Crook. Good Luck Ember , I would like you to win DB2’ Got Talent contest. I am almost going to miss my DB2’s got talent’s presentations preparation. But I think I did make some good friends. Thanks Scott Hayes , Susan Visser, Martin Hubel and Klass Brant , they always liked my presentations.
The topic of my presentation was “ These tennis shots make me win my match in just two sets (1.5 hours)” . In this I compared my SQL’s which I always carry to my first day of every consulting job . I am attaching a pdf of the presentation here.
All these SQL’s are tested by me and they work pretty good on Linux and windows. Please test them and if they don’t work get back to me.
Tip of the Week : Always make sure that your user and system temporary tables are distributed over file system or disks for better performance.
Here is the link for my presentation
That was the topic of my March 8th presentation at DB2’s Got Talent Contest. I discussed how I was able to write input data feed for Netezza in delimited format. Because the time was so short I was not able to discuss the 9 th slide “Some Monitoring SQL’s to
more
