My Oracle Support Banner

Cursor Modes in Siebel Scripting on DB2 UDB for z/OS and OS/390 (Doc ID 478276.1)

Last updated on MARCH 13, 2020

Applies to:

Siebel Tools - Version 7.5.1 SIA [15026] and later
IBM z/OS on System z
IBM z/OS (OS/390)
Area(s):Siebel VB/eScript/COM
Release(s):V7 (Enterprise), V8 (Enterprise)
Database(s):DB2
App Server OS(s):IBM OS/390, IBM zOS
Latest release tested against:V8 (Enterprise)
Checked for relevance on 11-Sep-2013
Keywords:DB2, OS/390, z/OS, Cursor, mode, ForwardOnly, ForwardBackward, thread, threads, management, script

This document was previously published as Siebel Technical Note 592.


Purpose

This technical note explains how to write Siebel VB or eScript queries to prevent unwanted database threads on DB2 for z/OS and OS/390. Careful handling is required because of how the cursor in DB2 behaves when the script completes. The choice between ForwardOnly or ForwardBackward cursor modes affects the number of active database threads on DB2 for z/OS and OS/390. This choice must be made by the script to prevent exceeding storage limitations in DB2.

Scope

This document is informational and intended for any user.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 ForwardOnly Cursor Mode
 MaxCursorSize
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.