DanL Database Consulting is proud to offer the following services. Please email DanL today, or use the Contact Page to send a request for more information.
1 to 3 Day Advanced SQL Coding and Performance Seminar
This cross-platform SQL class can be customized to meet your needs and given on site using your facilities for a true in-house custom experience. Dan's many years of SQL coding and performance tuning are incorporated into the class so that each topic is presented from both a functionality and performance perspecitve. Proactive and reactive SQL performance monitoring is addressed, and a hands-on workshop is also available. Click here for the class abstract. The one day version of this course is occassionally offered publicly. Check the events page for any upcoming publically available dates.
1 Day DB2 Advanced Programming, Automation, and Performance Seminar
This cross-platform advanced features class can be customized to meet your needs and given on site using your facilities for a true in-house custom experience. Dan's many years of database administration, application design, SQL coding and performance tuning are incorporated into the class so that each topic is presented from both a functionality and performance perspecitve. Click here for the class abstract. This course is occassionally offered publicly. Check the events page for any upcoming publically available dates.
DB2 for z/OS Performance Audits
If you are looking at a mainframe operational budget thatís dramatically increasing, then maybe itís time for a database performance audit. A comprehensive review of production DB2 subsystems, databases, and applications can potentially uncover hundreds of thousands, if not millions of dollars, of cost savings through database, application, and SQL tuning. This type of review would include analysis of DB2 subsystem and data sharing parameters; DB2 database configuration; and most importantly, DB2 application and SQL performance. The result of a DB2 performance audit would be a report that includes identification of relatively poor performing applications and databases, along with directions for tuning them to achieve maximum cost savings.
Dan Luksetich not only utilizes his years of experience as a database application architect, database administrator, DB2 application developer, and SQL instructor, he also takes advantage of the information acquired from the dozens of previous performance audits he has conducted for clients all over the world. Every customer employing these services has benefited from the identified cost savings!
Unlike the competition, there is no team involved and no extensive on-site engagement. These performance audits are always conducted in less than one work week, with a report delivered a few days later. Why hire DanL Database Consulting? He doesnít sell software products and he doesnít sell hardware, and so there is nothing for him to do except solve your performance problems at the lowest cost possible!
DB2 for z/OS Performance Tuning
Dan Luksetich can be available for short or long term DB2 database and SQL performance tuning. His techniques identify the applications and SQL that can provide the greatest savings first. The tuning is non-disruptive, and he shares his information with your staff so that they can continue the tuning process forward themselves.
Long and Short Term consulting
Dan Luksetich is available for DBA services for DB2 on z/OS, as well as DB2 for LUW. Dan has extensive daily experience with DB2 for z/OS, DB2 for Windows, DB2 for AIX, and DB2 for Linux. Service is available at an hourly rate for any long or short term engagement. Put Dan's 24 years of DB2 experience to work for you!
Migration Planning and Implementation
Dan Luksetich has been involved in new migration planning and implementation at several customer sites, and has gone through the DB2 11 for z/OS migration planning workshop. He has onsite experience moving customers to DB2 10 and 11, and can help you plan for the migration, implement the new software, and begin taking advantage of all the new features!
Please email DanL today, or use the Contact Page to send a request for more information.
All content copyright ©2012-2016 DanL Database Consulting
IBM is a registered trademark of International Business Machines Incorporated
DB2 is a registered trademark of International Business Machines Incorporated