Search results for query: *

Please refer to below link; you may get some insight http://wiki.ispirer.com/sqlways/troubleshooting-guide/informix/export-conversion/data/function-sequence-error

The error sounds like you have ended up with glitches in some indexes. Consider running onchecks to confirm that there is a problem with an index. Try oncheck -- which will show more detail for the command. Once you have identified a problem sourced index, drop and recreate it.

The data you fetch from disk is stored and controlled in server's limited shared memory. In single go entire data scope is not populated into shared memory but based on amount of free shared memory available, the online manages to store retrieved data. It is a best coding practice to use...

Get every user defined table names in a database use SQL below: select tabname from systables where tabid > 99; Please note that to set the access granularity you may have to revoke access given to the object "public" if any, for each table. eg. revoke all on "owner".table_x from "public";

Have you tried dbload?

This kind of history data is not stored in any part of the metadata. The current info can be pulled from the SQL below: select tabname ||' '|| created from systables where tabid>99 ;

It looks temp sort space is going out of space. Introduce the environment variable PSORT_DBTEMP to place sort files. export PSORT_DBTEMP=/tmp to place it on alternate locations try this: export PSORT_DBTEMP=/tmp:/tmp2

1. delimiter "" removes the default pipe data delimiter If it fails try to use || (concat) Unload to c:\junk\test.txt select field1|| field2|| field3 from file1 ; 2. unload statement knocks off spaces in the data. Use nvl function to fill the place holders. Unload to c:\junk\test.txt select...

Just to make sure... onmode -z <sid> ie. session id and not <pid> May be a transaction is in progress in the sid in question. You may try to end it by: xsid=`onstat -u | grep <sid> | awk '{print $1}'` onmode -Z $xsid onmode -z <sid>

Is the finderr -208 explanation helps?

This sounds strange! Do you have dual login? If so, in one of the login, DBDATE may not have been set to British format.

You may use: sed 's/^M//g' input_file > output_file Note: ^M is Ctrl+v Ctrl+m

Dan, not very sure but it looks some access componants are missing at local setup. Have you installed/updated your MDAC (Microsoft Data Access Componants)? If not go to the Microsoft website and do a search on MDAC.

Jack, if you have preserved all data of your earlier dbexport, you may edit your <database>.sql file. In all the "create table" and "create index" tables suffix "in <space_name>" syntax. Once you have completed this, drop the database and import the data afresh to multiple dbspaces. In the...

The ISA installation program adds environment variables (INFORMIXSERVER, INFORMIXDIR, ONCONFIG ) to the isadir/etc/isacfg file. Review it for its correctness. One more point - You must start the ISA Apache HTTP server before you can access ISA. To start the server manually as user informix, run...

1. Direct the output of the statement to file1.sql unload to file1.sql select name from sysmaster:sysdatabases where name not in ('sysmaster','sysutils','sysusers'); 2. Prefix drop syntax sed 's/^/drop database /' file1.sql > file2.sql 3. Substitute | with ; sed 's/|$/;/' file2.sql...

slightly on off-subject: "oninit: Fatal error in shared memory creation" message is due to execution of oninit command while dbserver instance is already initilized in the shared memory. To ascertain if shared memory initialization has any issues, first do a complete shutdown by onmode -uky and...

IDS configuration seems to be OK for a test box. Post outputs of commands below: 1. onstat -g dis 2. grep informix_lop /etc/services

A case where dbserver nearer to overwrting a LL (logical log) that ER (Enterprise Replication) has not yet processed is called DDRBLOCK mode. Hence you get to see this message. Refer Chapter 9-14 of IBM Informix Dynamic Server Enterprise Replication Guide for more details. PDF Book Link...

Hi, When statistics are updated with low keyword, information is not updated at sysdistrib table, hence no traces of timestamp is available. Keywords medium and high will generate columnwise data bins in distrib table. Following SQL statement will show when & how the last update statistics...