DB2 Load testing directly

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
Natarajan.in
Member
Posts: 1
Joined: Fri Mar 02, 2018 8:49 am

DB2 Load testing directly

Post by Natarajan.in » Fri Mar 02, 2018 8:52 am

Hi, We have a requirement to generate load directly to DB2 instead of going thru CICS app. We are planning to do this via JDBC. However we heard that all jdbc calls will be directed to ZIIP processor but CICS goes thru General processor.

I believe this makes a huge difference in response time.

Any idea on how to mitigate this (can we disable ZIIP so that all JDBC calls go thru General ?)? Or Any workaround for load testing DB2 directly apart from JDBC ?

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others