Login | Register   
RSS Feed
Download our iPhone app
Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips
Tip Bank > Database Development > Database Administration

Database Administration - Page 3

41-60 of 73     Previous     Next
Informix Ontape Backups
by DevX Pro
I need to do an ontape Level 0 backup but I need to bypass the "Press Enter to Continue." Simply put, I want to type "Ontape -s -L 0" and not get prompted to "Press Enter to Continue." I am currently running Informix 7.23 on an AIX 4.2. Any ideas ?
Informix Backups Error Message
by DevX Pro
We have Informix IDS 7.30 running under SCO 5.0.5. Backups by ontape fail with an error: "I/O read chunk 90, pagenum 2, pagecnt 1 --> errno = 9" But when we are doing normal queries, it's all fine. Any ideas?
Ontape for Backups to Disk
by DevX Pro
How can 'Ontape' functions be used to back up Informix/Lawson DB to disk? Is dbspace required or can a large area in a directory (e.g., /gsc/bigspace) be used?
Problem with Using Ontape
by DevX Pro
I am running Informix 7.3 on SCO Openserver 5. I run Ontape every morning and it has been going fine. Starting yesterday I've been getting the following error: Archive on rootdbs, onlinedata ABORTED. Aborted by client My tape drive is OK as well as the tapes. I can do a normal CPIO to it and read from it. Any help would be appreciated.
PDQ and Xtree
by DevX Pro
How can I set the PDQPRIORITY for every user in the database? I am also trying to get Xtree to work on the same system so I can better analyze user queries but can't figure out how to do that either.
Generate Audit Table Trigger Code
by David Satz
This code will generate code to do a column-by-column comparison against a table, assuming that you are joining the inserted table (aliased as "i") with the deleted table (aliased as "d") in a ...
Processing of Large Batch Transactions in Oracle
by Jayanta Sengupta
At some point, you must have encountered a "Snapshot too old" error when running a huge batch transaction. Then you find that you may have to restart the process all over again when 80 percent of ...
Function Sequence Error
by DevX Pro
I have WinNT4.0, Service Pack 5.0 SQL Server7.0, ODBC Driver for SQL I have a servlet program that connects to a JDBC-ODBC bridge and accesses the database. If I execute any SELECT statements I get: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Function sequence error If I run the same servlet program in another setup (NT4.0 service Pack 4.0, SQLServer6.5, ODBC Driver, I don't get any error. Why is this?
Can Add Records But Not Update Them
by DevX Pro
I am developing an application package with VB 6.0 and SQL Server 7.0. My problem is that I can add new records to the ADO recordset but I am unable to update the record from the VB form. I have given the permission to select, insert, update, and delete the data at the SQL Server end. In ADODC the recordset type is dynamic. Presently, there are only 2,000 records in that table. What do you advise?
Hiding SQL Server DE System Tables
by DevX Pro
The Enterprise Manager (or whatever it's called now) shows all the systems tables when you navigate down to the tables in a database. How do you hide the system tables?
Changing an Installed Code Page
by DevX Pro
How do I change the code page in SQL Server 7.0 once it has been installed?
Uncontrolled Shared Update
by DevX Pro
What situation produces incorrect results in an uncontrolled shared update?
Ensure the Stability of Your Database
by Joseph Lax
As a database administrator, it is your responsibility to be concerned about anything that might affect the stability of your systems. In that vein, it is not enough to back up your database ...
Watching Index Use
by DevX Pro
The goal is to watch queries for their use, nonuse, or abuse of indices (using SQL Server 6.5). One of the problems is to be sure that a given index is no longer in use. If an index is dropped, is there any way to watch for a table scan--either on this particular table or in general.
SQL Server Errors
by DevX Pro
When rebuiling indexes I receive an error. Error 1501:[SQL Server] Sort Failure What is happening, and what do I need to do to fix this problem?
Documenting my tables, triggers
by DevX Pro
We use SQL Server 6.5 (7 in a few weeks). I'm looking for a good tool to generate ERDs and overviews of my database tables. Which software can you recommend me for this purpose?
Starting NT Services for SQL Databases
by Ken North
The Windows NT installation process for SQL servers from Oracle, Microsoft, IBM, Sybase, and Informix installs NT services. Not all products include a graphical tool that enables you to start and ...
Log truncation
by DevX Pro
My database and log keep filling up and I can't truncate the log. Any suggestions?
Rename a Login
by DevX Pro
Is it possible to rename a login?
Automating DBCC checks
by DevX Pro
I need to run DBCC checks on my databases every week, but I was advised not to use the database wizards in MS SQL 6.5. Can DBCCs be setup to run automatically?
41-60 of 73     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date