Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by martynh
-
BLOB question on size
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 -
question about authorities
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... -
db2 express-c remote access
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... -
Kernel panic on RHEL 5 and DB2 9
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... -
Kernel panic on RHEL 5 and DB2 9
We are testing DB2 9.1 on RHEL 5, on DL380 G4 servers. At random intervals we get a kernel panic. The issue 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... -
Check for existence of a Stored Proc.
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... -
db2fmp gone mad
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... -
fmp processes looping
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... -
Returning the number of rows and the details in the same result set?
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! -
Identify a db2 backup file type
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... -
Identify a db2 backup file type
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... -
db2fmp gone mad
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... -
db2fmp gone mad
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. -
download DB2 for temporarily use??
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... -
getting db2 to listen for jdbc connections
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...
