Performance Tune DB2 z/OS v10 subsystems and SQL queries including but not limited to Predicate Staging, Optimizer estimation, Access Path Strategies, Join Methods using IBM EXPLAIN utility, and IBM Data Studio's Visual Explain.Provide DB2 / IMS, Data Replication, DASD, MQ application requirements / support for High Availability Very Large Resilient Systems.Certified/Training: DB2 v10 SQL Optimization / Tuning.Databases: DB2 z/OS v10.1 IMS v12, Oracle 9i.Languages/Tools: DB2 Sysplex, DB2 Native Stored Procedures, Mainview, IBM Data Studio, BMC Cat/Chg Mgr, REXX, TSO/ISPF OS/JCL, TOAD DB2 / Oracle, PL/SQL, Ansi SQL, CICS, Cobol/Cobol II, CMM Level II, Candle's Explain, FILE-AID DB2, CA-1, SPUFI, VIASOFT, XPEDITER, OMEGAMON XE PE, PROEDIT, DFSORT, MS Project, MS Office Word, Excel, PowerPoint, Librarian, SDF II, FTP, IBM Utilities, PANVALET, Control-M, Endeavor, ACF2, Visio, Lotus Notes, JSS Job Scheduling System.
Environments utilized include IBM CICS, COBOL, DB2, IMS, MQ, REXX, z/OS. Rapidly find the root cause of system, database or application performance issues and make necessary corrections with our Spotlight on DB2 LUWcomponent.Ĭreate and manipulate database objects through intuitive GUIs.Ĭustomize compare-and-sync of data, objects or entire schemas to easily identify differences.Įnable application performance tuning with automated SQL scanning, optimization and index impact analysis.20 years experience in software engineering encompassing all SDLC phases surrounding database administration DBA, system analysis and design, software design, implementation, integration, conversion, system/unit testing, support and documentation of web apps, online and batch systems. Performance bottlenecks detection, diagnosis and resolution Generate queries and reports and perform SQL development and optimization faster. Quickly and easily build SQL with minimal keystrokes or with the visual query builder and never touch your keyboard. Choose Toad for IBM DB2 to simplify database management so you can devote more time to innovation. Toad for IBM DB2 provides a complete DBA suite for advanced administration, performance and change management and it provides a single, consistent toolset to manage both DB2 LUW and z/OS. Whether your DB2 instances are on premises or in the cloud, Toad for IBM DB2 helps ensure optimal application experiences and peak database performance. Backed by over a decade of development expertise and user input, this robust DB2 tool helps automate database management. Spend less time managing DB2 and more time innovating.Ĭomplete your daily administration tasks quickly and accurately with Toad™ for IBM® DB2.
0 kommentar(er)
