Search results for query: *

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...

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...

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...

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.

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; --...

We have just acquired a DL380 G3, with a 5i/532 Raid controller. We are running Red Hat Enterprise Linux 3. Using the web front-end of the Array Controller Utility (cpqacuxe) we can see the raid controller and how the disks are configured. From here we can also, it seems, tell that the disks...

I have just set up DB2 8.1 FP7 which is apparently the same as DB2 8.2. One of the changes is that you no longer require a C compiler to create stored procedures. There is no mention of functional changes, but we have a situation where an implicit change has occurred. The situation can be...

I've been happily running DB2 8.1 (currently FP6) on RHEL for almost a year now. When the server reboots DB2 automatically starts (I requested this at DB2 installation time). However, it occurs to me that I don't know how this actually happens, i.e. where is the command issued to start DB2 at...

Probably a simple question.... Suppose a situation where there are just two machines in a workgroup (no Domain controller). One machine runs an application, the other SQL Server 2000. Both machines are running XP. Is it possible for the application on the app server to connect to SQL Server...

We are specing a new server (a DL380 G3) to act as a database server. We will have 4 drives that we want to operate as two Raid 1 arrays. This will allow us to separate the database data and logs. The server comes with a Smart Array 5i Plus controller. Is it possible to achieve this with this...

Hi, We would like to buy a server with 2 Xeon processors to run SQL Server. However, initially, only part of the servers job will be to run SQL Server, so we only want to buy a single CPU license. Does anyone know if this is allowed? We would, of course, need to find a way to limit SQL Server...

We have a simple requirement. We have Bugzilla configured to send email to our internet mail addresses, e.g. martyn.hodgson@mycompany.com. However at the moment we just want the server running Bugzilla to send these messages to the local user accounts, e.g. martyn@buzillaserver.lan without...

Hi, I hope to test hot-swapping a disk in a RAID-1 array tomorrow on a DL380 with an Integrated Smart Array Controller. The server was bought second-hand without any set-up disks or manuals. The disk I am putting is in new, and unformatted, the server is running RedHat EL 3.0. My questions are...

When I used to administer DB2 on OS/390, when you created an index you specified its storage requirements, i.e. you created an indexspace, quite seperate from the table. I see references to this kind of thing in the UDB manuals from time to time. However, in the CREATE INDEX syntax specification...

I'm using RH9 and RHEL3. The installation of the software is via RPM packages. This is nice and easy. However, I want to reinstall one package because I have found there is an advanced option I want to set. This has to be done at build time. Is there a way in which I can 'expand' a RPM package...

I've just set up RH 9 with samba (2.2.7a-security-rollup-fix). When the first Windows client connects I get 47 smbd -D processes created!. This number gets higher and higher as other users connect and time goes by. After a few days (there are only 5 pc's at most connecting) I have to reboot the...

I've inherited a Compaq server with an &quot;Integrated Smart Array Controller&quot;, or so it says during the boot process. The server has no o/s at present. I'm trying to put Windows NT 4 on it to test it out. However, Windows can't see the logical drive (made up from 3*18 Gbyte drives). I...