Login | Register   
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips
Tip Bank > Database Development > Database Tuning

Database Tuning - Page 2

Optimization
21-40 of 145     Previous     Next
Informix Row Locking Problem
by DevX Pro
I created a simple SQL statement to update one row of a table in a transaction. I then updated a different row in the same table while this transaction was still open. I got a 107 ISAM error (record is locked). Now, the table is definitely set to row level locking and the table has no indexes to confuse the locking issue. Therefore, it seems not to be working. Do you have any suggestions?
Time Data
by DevX Pro
I am using Windows 2000 and ADO 2.5 with VB6.0 and I am retrieving a datetime field from an Informix database 7.3. The field contains time only. When the record is entered, that field is assigned only time; no date is entered. When I retrieve the data, all I get is an empty field (not null). When I tried to print the value of that field I get the Run-time error: '-2147217887 Multiple-step operation generated errors When I save the recordset using adoRecord.Save the original time values are in the saved file. I also get the original values when I use Microsoft Access and link the Informix table. I am using the same ODBC driver for ADO and Access. How can I read the time from the datetime field when only time is entered in the field?
SQL with Unix Arguments
by DevX Pro
How do I pass arguments from a Unix shell onto SQL for various SQL statements (e.g., select * from $tablename, create table $TABS, etc.)? Also, how do I get output from SQL within a SPL to several different files? So SQL executes many times and creates a different file each time. Tried to use OUTPUT, but gives some error.
Hyphen Or No Hyphen When Accessing DBACCESS
by DevX Pro
When accessing DBACCESS from a script, what are the consequences of leaving out the hyphen? What should we adopt as a standard, hyphen or no hyphen? Example: dbaccess mystores - OR dbaccess mystores
Chunk is Down
by DevX Pro
We are using IDS 7.30 FC7 on DEC/Unix 4.2. Two separate OnLine works on the same machine. Let's call them OnLine1 and OnLine2. While adding a new chunk (not mirrored) to the existing dbspace on the OnLine1 we specified its path to another chunk (not mirrored) which exists on OnLine2 by mistake, but the chunk added to the dbspace on OnLine1, and after a while it becomes down. Both IDSs are in the online mode, but we could not get Level-0 backup. Now we could not drop chunk and could not change its status to online. We tried with both onspaces -s command and onmonitor utility. Do you have any comments on this?
Error in Visual Studio Data View with CLI 2.40
by DevX Pro
I have installed the Informix-CLI SDK 2.40 (driver ODBC rev. 3.31) both in Windows 98se and NT 4 sp4, and I've encountered a problem with Visual Studio Data View when try to see tables from an Informix DB running on an AIX 4.3 host. I have problems with numeric data; the view is incorrect (0 when it must be 1). An older version of CLI SDK works correctly.
Using Mapinfo with Informix
by DevX Pro
I want to use Mapinfo with an Informix database, but I can't connect the database server from Mapinfo. The Informix dynamic server version is 5.0. My network protocol is tcp/ip, and the database server is working on a "sco 3.2.5.0" platform. Mapinfo is working on Windows98. What can I do about this problem?
Optimize Oracle's SQL Statement Cache
by Andrew Holliday
When Oracle receives a SQL statement to execute, it first looks to see ...
Error in Timed Job
by DevX Pro
I am getting an error ("Could not do a physical-order read to fetch next row" #244) while executing a job that runs a set of SQL statements every 30 minutes. When we stop the job and run it again after a few minutes, it runs fine. So I don't think it is a corrupted index file problem, as the book describes it. What else could cause this error?
Shared Memory Error
by DevX Pro
My Informix usually server starts fine, but when I try to add a database chunk with the onspaces command I get an error ("shared memory not initialized"). Any ideas?
Transaction State
by DevX Pro
How do I know if I am already in a transaction when I call a procedure from another one?
Use Undocumented SP_WHO2 Procedure Instead of SP_WHO for SQL Server 7.0
by Andrew Holliday
The sp_who internal procedure allows users to view current activity on the database. This command provides a view into several system tables (e.g., syslocks, sysprocesses, etc.). The sp_who command ...
Auto Start Full Text Index
by DevX Pro
Can I auto start full text index?
ASP Error: ODBC Driver General Error
by DevX Pro
I have been receiving the following (albeit general) error sporadically: "Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Informix][Informix ODBC Driver]General error." This error has occurred when the code accesses the datasource: (set conn = server.createobject ("ADODB.connection"): conn.open "DatasourceName". However, it happens only occasionally when using ASP. Cold Fusion does not yield the same type of error. Any suggestions?
Date Time Values in Parameterized Queries
by DevX Pro
I have a parameterized SQL statement like the following: "insert into eSession (ESessionID, eUserName, eLastActivityTime) VALUES(?,?,?)" It's parameters are 'bbb','name' and '2000/01/01 22:23:25', using an ODBC connection. I can't make the date work. Even using the ODBC timestamp format of {ts'yyyy-dd-mm hh:nn:ss'} does no good, although it does work when the statement is not parameterized, like so: "insert into eSession (ESessionID, eUserName, eLastActivityTime) VALUES('bbb','name',{ts '2000-01-01 22:23:25'})" Is there a generic solution that works with SQL Server, Oracle and Access (I know, but I was young and needed the money)?
Releasing Database Locks
by DevX Pro
How can I release all existing database locks for all the sessions a specific user has started?
Running Ace Reports from Within 4GL
by DevX Pro
My ace report/shell script did not wait for user intervention. I have solved that with: script.sh mytty But now the screen needs refreshing with a CTRL-R. Is there a stty command to do this for the users?
Slow Report Generation
by DevX Pro
I'm developing a VB client application (using VB5) with an Informix database in the backend. However, the report generation that Crystal Report incorporates has always been very slow. What should I do?
Dbspace Marked Down
by DevX Pro
I have tried to reorganize Informix chunks on my disks. So I stopped the Informix and started to copy chunks to a new location with a cplv command (AIX). After the copy was successful, I changed the links to new logical volumes, which contain copies of each chunk. But I misspelled the Informix chunk name in one link. So when I brought the Informix online, the dbspace that contained that chunk was marked as down. Dbspaces are not mirrored. How can I tell Informix that this dbspace is OK and that flag down should be removed? Data in this chunk are OK, because I have no problems with other copied chunks.
REPORT Functionality Within Informix
by DevX Pro
What does a return code of 100 mean on a START REPORT statement?
21-40 of 145     Previous     Next
Sitemap