what is package SYSSH200?

william giannelli

what is package SYSSH200?

what is package SYSSH200 used for and where can I find the bind "files"/dbrm for it?

thanks

Bill

Roy Boxwell

what is package SYSSH200?
(in response to william giannelli)
It is one of many packages for JDBC they are bound by a rexx and normally to the NULLID collection. They are only used as empty shells for dynamic SQL ( just for authorization and APPLCOMPAT).

Roy Boxwell
SOFTWARE ENGINEERING GmbH and SEGUS Inc.
-Product Development-
Heinrichstrasse 83-85
40239 Düsseldorf/Germany
Tel. +49 (0)211 96149-675
Fax +49 (0)211 96149-32
Email: [login to unmask email]
http://www.seg.de
Link zur Datenschutzerklärung

Software Engineering GmbH
Amtsgericht Düsseldorf, HRB 37894
Geschäftsführung: Gerhard Schubert, Ulf Heinrich

> On 8 Sep 2019, at 04:00, william giannelli <[login to unmask email]> wrote:
>
> what is package SYSSH200 used for and where can I find the bind "files"/dbrm for it?
>
> thanks
>
> Bill
>
>
> Site Links: View post online View mailing list online Start new thread via email Unsubscribe from this mailing list Manage your subscription
>
> This email has been sent to: [login to unmask email]
> Discover the best cloning tool on the market. Try BCV5 & the new BCV5 Masking Tool.
> ESAi also has powerful solutions for Buffer Pool Tuning, Log Analysis, TDM, & more.
> http://www.ESAIGroup.com/idug
>
>
> Use of this email content is governed by the terms of service at:
> http://www.idug.org/p/cm/ld/fid=2
>
Attachments

  • smime.p7s (3.9k)

Michael Hannan

RE: what is package SYSSH200?
(in response to Roy Boxwell)

See this website for some detail:

https://www.ibm.com/developerworks/data/library/techarticle/dm-0606chun/

200 is isolation level CS.

S is a "small package" (not sure which stuff is small or large).

H is Cursor with Hold. I hope people do not use "With Hold" too frequently when they don't need it. That is to keep Cursor open across COMMITs. However I see developers use it for no reason a lot.

Michael Hannan,
DB2 Application Performance Specialist
CPT Global Ltd

J&#248;rn Thyssen

RE: what is package SYSSH200?
(in response to william giannelli)

Hi Bill,

It's part of Db2 Connect.

Bind instructions here:
https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.qb.dbconn.doc/doc/c0005595.html

If you have Db2 Connect unlimited you can also bind from the license activation kit:

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.5.0/com.ibm.db2.luw.licensing.doc/doc/r0057377.html

In Reply to william giannelli:

what is package SYSSH200 used for and where can I find the bind "files"/dbrm for it?

thanks

Bill



 

Best regards,

Jørn Thyssen

Rocket Software
77 Fourth Avenue • Waltham, MA • 02451 • USA
E: [login to unmask email] • W: www.rocketsoftware.com 

2019 IBM Champion.

Views are personal. 

Greg Palgrave

RE: what is package SYSSH200?
(in response to william giannelli)

Hi William,

All the db2 'system' packages and their bind files are, surprisingly, in the documentation:

https://www.ibm.com/support/pages/db2-v111-bind-file-and-package-name-list

Unfortunately, they don't come with a detailed description for the most part.

https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.cli.doc/doc/r0007866.html

 

Cheers

Greg

 


In Reply to william giannelli:

what is package SYSSH200 used for and where can I find the bind "files"/dbrm for it?

thanks

Bill