Forum: IBM DB2

I'm using sqlj to access a mainframe db2 database from a windows client. When executing db2profc the jvm dumps but only if there is an sql...

Hi, I have got multiple large backups on tsm which are inactive - they show up when you run the query : dsmc q backup -subdir=yes -inactive=yes...

Hi all, I'm trying to write a sql file to load up some initial data into a database. Some of the loading is done by calling procedures and getting...

Hi I am trying to insert values in to the same table through 2 different java programs. They are just 2 straight forward insert statements. I...

Hi all, Ok me again. I have a proc that looks something like this ... CREATE PROCEDURE loadtestdata() MODIFIES SQL DATA NOT DETERMINISTIC...

I now know that I cannot use client application written in embedded SQL to receive record sets, that only an application using CLI can receive...

The replication guide and reference says under "Data type restrictions": Binary large objects (BLOBs), character large objects (CLOBs), and...

UDB 8.1 WSE without fixpack on win2000 server installed: I try to install FP3 WSE. It tells me: "A DB2 product at version 8, release 1,...

Hi there, Why don't you put some kind of controls on the db2set command ? Let's take an example: db2set DB2_HASH_JOIN= Y/N, NO, OFF, YES, NO;...

Once you have W2K / XP clients doing authentication (domain logons) against the Novell servers, it's just a matter of enabling client authentication...

Hi there, I've downloaded FP3 fixpaks and installed them smoothly, thanks for getting rid of the windows installer pb. Can you give a date for...

Further to previous post , please ignore - the following fixpak 8 APAR (originally for AIX) looks near-identical, certainly worth a shot: ...

You may try this, we've used it often in different environments: @echo creating user DB2ADMIN net user DB2ADMIN YOURPW /add net localgroup...

Hello, I am trying to use GET and PUT command to move the SQL stored procedure from development machine (Win. DB2 FP10) to production machine...

I just installed PE8.1 on Linux. I used db2 to create a new database TEST. Via db2, I can connect and execute a select statement on a test table....

Hi, Silly me just killed a Database by removing the Database Directory itself ($INSTANCEHOME/db2inst/NODE0000/SQL0001, or whatever). I dont have...

Helpful folks, I seem to be misunderstanding the use of the CASE statement as used within a WHERE clause. I had thought that one could do the...

Hello, Please, is there a way of finding out the Locale setting for a db2 database? thank you, sean

I have Russian data that I want to put into DB2. I can read the file in Wordpad, not in notepad etc. I have saved it as uncode, tried different...

I'm curious how other shops have their DB2 Connect gateway environments set up. For instance, if you have 3 DB2 subsystems DEV, TEST and PROD, do...