Search results for query: *

You can be sure it won't take less as DB2 won't try to compress it unless you have some non-default settings. Have a read of "Space requirements for large object data" at http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0000927.htm

I've not really used DB2 on Windows, but I doubt what you are trying to do will work directly. When you create an instance, the default Authentication Type (in the database manager configuration file) is set to SERVER. This says to DB2 to allow clients to try to connect but then use the local...

A few basic things to check: 1. Have you got a record in /etc/services for the db2 instance? 2. If 1. then is it using port 50000. 3. Is db2 specifying the correct service name. Yo can just specify the port, but I wouldn't - it's easier to do it as a service name. 4. Has the server got a...

We were using Fix Pack 2. I have just completed a complete rebuild of the server and have applied the interim fix pack 2a. The server crashed again within 2 hours of use. IBM support pretty well ignored us when I raised the issue. Red Hat have done the same. As requested, we set up kdump and...

...looks like one for Red Hat, but I ask here because the hardware and software combination we are using is very simple and conventional. The only *unusual* aspect is that we are running DB2 9. The problem occurs during periods of high io activity, often during db2 backups, but also during dump...

I think it's worth mentioning here that if you have more than one stored proc with the same name within the same schema, but with different profiles, you will need to reference syscat.routineparms. This will give you the basis for working out the profile for each procedure. If you join...

I'd forgotten about this. For the sake of anyone finding this in the future, the problem did not recur on the original (single DB2 instance) server. However, it did recur on another. What was spooky was that on the second server it happened with both instances that were running there. This makes...

DB2 8.2.4 on RHEL 3 (Compaq DL380 and HP DL380 G3) Twice now, on different hardware (noted above), I've seen a DB2 fmp process apparently looping and consuming all spare cpu cycles. The processes are being run by the fenced user. On both occasions stopping db2 has had no effect and I've been a...

My best suggestion (and's not elegant) is: select t.*, counter.num from sometable t , table (select count(*) as num from sometable) as counter Performance shouldn't be bad as the count part should resolve first as an index only access, but I'd comment my code to explain what I'm doing here!

The list history command is fine so long as you have the source DB2 instance available. In my scenario I'm trying to set up something that would work if the source DB server had died and all I had was the backup file. In fact I have managed to answer my own question. The command db2ckbkp, when...

We create 2 types of full backup: online with logs included and (once a week) offline. The backup file names have the same format but, of course, if you want to restore from them, the commands are slightly different. I'm trying to script automatic restores from these files onto a different...

I thought that too. However, there's nothing in these to suggest a problem. The rate that the process is burning cpu cycles I don't think it's on speaking terms with the rest of the server. I've rebooted the server and on reboot all looks quiet, so I'll watch it now. I've also opened a PMR...

DB2 8.2 FP4 On RHEL3 The db2 process db2fmp is using 100% of a cpu. It shows no sign of doing anything other than burning cpu cycles. Anyone any suggestions what's gone wrong? We have 2 other machines at the same software level that are quite happy.

Restoring from version 6.1 to 8.2 (I guess this is what you downloaded for free) onto different platforms is going to be a real challenge I'd guess. I've not done it but my first approach would be to look at the export and import commands (and also the load command). These allow transfer of data...

If you used the graphical installer, I would have expected the entry in /etc/services to have been created for you. It sounds to me as if you may have a more general problem. I wonder if you installed DB2 to use tcp/ip? In case you haven't done this, check that the dbm cfg parameter SVCENAME...

I think you are after the GET DIAGNOSTICS statement. The MESSAGE_TEXT and DB2_TOKEN_STRING should contain the information you want Regards Martyn Hodgson

We are running DB2 8.2 on RHEL 3, on a Compaq DL380 G3. Tablespaces are on one mirrored disk pair, the backup directory is on another. Disks are standard Compaq 15K, 36GByte, hotswap, scsi connected. Backups of small databases (backup files c120 Mbytes) take about 7 minutes. There is no real...

Using DB2 8.2 on RHEL 3, I created a test database, put some test data in it and did an online backup specifying 'include logs'. The backup was fine and I managed to do a restore and rollforward with it. I then dropped the database and tested restoring from the backup file, which I had kept...

We have a small office (<30 people) each with a PC connected via cat5/ethernet. We want a telephone system that will allow each PC to act as a phone, via a headset. We don't want separate phones and their associated cabling. Each PC would be assigned an extension number, and if the PC was not...

What am I missing here? Take a simple table defined as: create table tab1 (col1 integer not null unique); Then from the db2 command line processor I run the following commands -- set auto commit off update command options using c off; -- check the command options list command options; --...