I am attempting to install Sybase ASE 15 on a SuSE SLES 10 (ia64) system and the install goes through till it gets to the point it begins the configuration of the servers. I then clicked next and on the next screen I got the message Adaptive Server configuration failed with the message...
I am trying to find a way to monitor occurance of deadlocks and the count of the occurances in the database without having to parse the trace file. Does anyone have or know of a script that will enable me having connected to the database whether locally or remotely, run the query to check/find...
I have a monitoring application that is executing select count(*) from sys.dba_extents for an Oracle database with over 15 TB of data and this is taking 20 minutes and as a result is affecting the overall monitoring application's performance.
The goal is to get the total number of extents...
Does anyone know the maximum number of Adaptive Server Enterprise version 12.5.x instances one can install on a single server(Unix or Windows)?
Thanks,
Attick111
I tried to use the snapshot monitor (get snapshot for tablespaces on mydb1) but as show below it lists Total pages and number of used pages as zero. My server has an AIX 5.3 installed as the OS and DB2 8.2 fixpak 8.
Does anyone have a better way of collecting this info or determining spaced...
In have A zLinux machine (64-bit) and prior to installing went through the Oracle install docs plus Werner Puschitz's install document on "Installing Oracle Database 10g on Red Hat Enterprise Linux AS 3 and 2.1, Red Hat 9, and on Red Hat Fedora Core 1 and 3". When I run the install I keep...
I need to migrate one of my production systems from DB2 UDB v6 on an AIX OS platform(4.3.3 which I plan to upgrade to 5L) to DB2 UDB v8. Has anyone done this migration before and has any tips on how to smoothly perform this migration?
Attik
I have a set of scripts which I am executing on a Windows 2000 Server with UDB 7.2 and they all run fine provided I have a smaller set of records. However, when I attempt to processed a larger set I get an error as follows....
DB21034E The command was processed as an SQL statement because it...
I have 2 DB2 databases installed on a windows 2000 server and cannot connect to them. I can however connect to other databases I have cataloged on this server. I looked at the db2diag.log file and found this error message....
2003-08-20-16.32.15.359000 Instance:DB2 Node:000...
I just installed a Web Server which i intend to host on my private network. The Web Server has been assessible until I installed Norton internet security. Does anyone know how to configure norton Firewall for people to be able to access my Web Server?
Does the Windows (W95/98/ME/NT/W2k) Registry store the machine's serial number? If it does, how do I find it? Also is there any available utility (freeware, shareware) that is able to extract the serial number from the Registry if not, is there one which can extract the serial number form the BIOS?
I have a Location table (LocationID, LocationName, LocationAddr, LocationCity, etc) and on my form page I have two drop-down menu list. What I want the customer to do is from the first drop down menu list, first select a city (query will perform a...select LocationID, locationAddr, LocationCity...
I have a Form page (registform1.cfm) which calls an action page called 'processme.cfm'. This page then first checks to make sure the username entered doesn't already exist in the database. if it does, I use the <CFLOCATION> to return the already filled in fullname.
<CFIF...
Does anyone know the DB2 equivalent of the following Sybase T-SQL statement
@numb int
select @numb=67
select @numb = @numb + 1
OR
select * from mytable where code_num > 67
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.