Unlocking DB2 table/row locks

michelles · *nix forums beginner Joined: 13 Jul 2006 Posts: 1

I don't know if you ever resolved this, but we just had similar problem.
What version of DB2 are you on? We just upgraded to Db2 V7, with DB2
connect 8.1 and DB2 client 8.1.2. We also were in the middle of upgrading
DB2 Clint to Service pack 12. Well anyway, all went back to upgrade to
DB2 V7 on mainframe. We needed to increate IDACK from 30 to 50, MAXDBAT
from 64 to 200 and CONDAT from 64 to 200 and CTHREADS from 130 to 200.
This seemed to fix the issue.

cwahlmeier@data-tronics.c · *nix forums beginner Joined: 14 Jun 2005 Posts: 11

michelles wrote:

C.E.O. Gargantua · *nix forums beginner Joined: 16 Jul 2006 Posts: 8

But that's for using ODBC ( which requires the CAE ) -- which I don't
want to use.

I'm using the DB2 Provider for .net

Here is a description of the DB2 Provider ( and the ODBC and Ole
technologies as well) :

http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0402chong2/#scenario3

The problem is I don't know how to identify a "database" name on the
as/400 as400

Rex Moore wrote:

mg · *nix forums beginner Joined: 30 May 2005 Posts: 26

Have you tried the name of your AS/400?

at the command line type: STRSQL and press <Enter>

the next screen should tell you the name of your relational database
which in my case is the machine name.

C.E.O. Gargantua wrote:

C.E.O. Gargantua · *nix forums beginner Joined: 16 Jul 2006 Posts: 8

I used the command that rex suggested and came up with

Entry Remote Location
S10DCD4B *LOCAL

mg wrote:

C.E.O. Gargantua · *nix forums beginner Joined: 16 Jul 2006 Posts: 8

Thank you Rex!

Does the CAE .net provider include the MSM files for .net ( so I can
create an installable application with the provider, and not have to
install the full CAE on the target ).

Rex Moore wrote:

C.E.O. Gargantua · *nix forums beginner Joined: 16 Jul 2006 Posts: 8

Well, unfortunately they have not installed the sql tools on the as/400
so that command does not exist on my machine!

mg wrote:

Rex Moore · *nix forums beginner Joined: 16 Jul 2006 Posts: 2

The latest version of iSeries Acces for Windows (formerly CAE) includes a
..NET provider - that is what my example uses. Please refer to this redbook
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm
Because it uses IBMDA400 in the connetion string does not mean it used ODBC
or OLE/DB. It was released in 2004. That release of CA 5.3 is more recent
than the article you refer to (2003). The name of the AS/400 database can
found by WRKRDBDIRE on the AS/400. I do not know if that value will work
with the DB2 UDB provider. I use the CAE .NET provider becasue I believe it
is optimized for the iSeries. Good luck

"C.E.O. Gargantua" <usb@cord.blah> wrote in message
news:352eflF4hpr54U1@individual.net...

C.E.O. Gargantua · *nix forums beginner Joined: 16 Jul 2006 Posts: 8

Frans Bouma [C# MVP] wrote:

Rex Moore · *nix forums beginner Joined: 16 Jul 2006 Posts: 2

You are getting a lot of advice. I normally install iSeries data components
by doing a selective setup from the cd. There are other ways. Look at this
redbook
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/info/rzaij/rzaij.pdf
you may find the section "create a tailored installation image of iSeries
access for windows" interesting. It is on page 36 of the pdf.

The doumentation (redbooks) with examples is a little lacking at this time.
Online help (with coding example in both vb and c# ) is available in iSeries
access help.

The db2 connect product would have to be installed on each client. You would
know it if you had it. I see others have suggested it. I found the db2 -
udb - connect way cumbersome - too many layers - I never got it to work as
well as I wanted. The runtime requirements are greater than the iSeriies
..Net provider. I tried the UDB way and gave up when IBM came out with the
iSeries .net provider. It was a big hooray from me.
More info -
http://publib.boulder.ibm.com/infocenter/iseries/v5r3/ic2924/index.htm?info/rzaik/rzaikdotnetprovider.htm

"C.E.O. Gargantua" <usb@cord.blah> wrote in message
news:352tpaF4h1forU2@individual.net...

C.E.O. Gargantua · *nix forums beginner Joined: 16 Jul 2006 Posts: 8

Here's the scoop. After installing the iSeries .NET Data Provider,
there is a .net DB2 iseries provider v10 in the references list.

And, my .net setup program recognizes the IBM.Data.DB2.iSeries.dll
dependency ( and hopefully will bundle it when I deploy ! ).

This code then works:

try
{

="Data Source=192.168.1.43;User Id=JBAILO;Password=XXXXXX;Default
Collection=DataLibrary;";

iDB2DataReader iRead ;
iDB2Connection iconn = new iDB2Connection(myConnString);
iconn.Open();
iDB2Command icmd = new iDB2Command("SELECT * FROM $MYLIB.MYFILE",iconn);
iRead = icmd.ExecuteReader();

} catch (Exception e) {Debug.WriteLine(e.ToString());}

Last thing on my wish list?

A way to specify a Member of a multi member file in a SQL statement (
MYLIB.MYFILE.MYMEMBER ) without throwing an error.

Rex Moore wrote:

Robert Comer · *nix forums beginner Joined: 16 Jul 2006 Posts: 1

user · *nix forums beginner Joined: 21 Mar 2005 Posts: 35

The problem is that the iSeries member concept is not an sql standard. It
is an iSeries thing. The ALIAS thing works. Another solution is to create
a cl program on the iSeries that receives the member as a parameter. CL
overrides to that file/member and runs an rpg program with embedded sql that
returns data. Then create a stored procedure for the cl that takes an
input parm (for the member) . Then call the stored procedure passing the
member name from your .net application. This will work - I have done it.
But, it invloves programming on the iSeries. It sounds more complicated
than it is. There may be simpler ways. I find the iSeries .net provider
works much better with the iSeries than the earlier ole/db provider -
especially when dealing with stored procedures.

"C.E.O. Gargantua" <usb@cord.blah> wrote in message
news:3558bqF4gqrpdU1@individual.net...

Google