dbimport command

IDS version: 11.50.FC5 OS: Solaris 10 Hi, I'am currently importing a database using dbimport command. It takes a while, the job is running for 2 days now. It is loading the same table for many hours now (I see it when I run onstat -g ses SESSIONID). However, I cannot see what values are currently being inserted into the table. Is there a way to connect to the database and check how many rows have been loaded in that table so far? When I try to connect to the database using dbaccess command, I get the following error message: 425: Database is currently opened by another user. 107: ISAM error: record is locked. Thanks

Finding the individual table can be a challenge, but onstat -t shows the accurate number of rows for all open tables ( and the one you are inserting into will be there. do and onstat -t every couple of seconds an see which table is picking up rows. Once you have identified the tblnum you can get creative on what you want to see. George. From: "Georges Martin" <georges_martin_1@hotmail.com> To: ids@iiug.org Date: 08/10/2010 02:50 PM Subject: dbimport command [20816] Sent by: ids-bounces@iiug.org IDS version: 11.50.FC5 OS: Solaris 10 Hi, I'am currently importing a database using dbimport command. It takes a while, the job is running for 2 days now. It is loading the same table for many hours now (I see it when I run onstat -g ses SESSIONID). However, I cannot see what values are currently being inserted into the table. Is there a way to connect to the database and check how many rows have been loaded in that table so far? When I try to connect to the database using dbaccess command, I get the following error message: 425: Database is currently opened by another user. 107: ISAM error: record is locked. Thanks ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Run onstat -t and you will see table or fragment's nrows and npages increasing. This will be the currently loading table. This should provide you with the information you desire. Do not forget there are alot more action besides loading done by dbimport. Just a few hints. 1. dbimport creates indexes and update stats so setting PDQPRIORITY up 2. Increase the amount of DS memory you have to speed up the sorting operations 3. set the environment variable FET_BUF_SIZE to 32700 to increase the insert cursors buffer size John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 08/10/2010 12:49:18 PM: > [image removed] > > dbimport command [20816] > > Georges Martin > > to: > > ids > > 08/10/2010 12:50 PM > > Sent by: > > ids-bounces@iiug.org > > Please respond to ids > > IDS version: 11.50.FC5 > OS: Solaris 10 > > Hi, > I'am currently importing a database using dbimport command. It takesa while, > the job is running for 2 days now. > It is loading the same table for many hours now (I see it when I runonstat -g > ses SESSIONID). However, I cannot see what values are currently > being inserted > into the table. > Is there a way to connect to the database and check how many rows have been > loaded in that table so far? > When I try to connect to the database using dbaccess command, I get the > following error message: > > 425: Database is currently opened by another user.> > 107: ISAM error: record is locked.> > Thanks > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Connect to the server without opening a database, SET ISOLATION DIRTY READ;, then try to open the database. Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Aug 10, 2010 at 3:49 PM, Georges Martin < georges_martin_1@hotmail.com> wrote: > IDS version: 11.50.FC5 > OS: Solaris 10 > > Hi, > I'am currently importing a database using dbimport command. It takes a > while, > the job is running for 2 days now. > It is loading the same table for many hours now (I see it when I run onstat > -g > ses SESSIONID). However, I cannot see what values are currently being > inserted > into the table. > Is there a way to connect to the database and check how many rows have been > loaded in that table so far? > When I try to connect to the database using dbaccess command, I get the > following error message: > > 425: Database is currently opened by another user.> > 107: ISAM error: record is locked.> > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0016e646a1e0a66e30048d7e55ad