SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 01:49 AM
| ||||
| ||||
 set integrity after load Hello, I have loaded a lot of tables into my database - some tables with foreign keys, so that when I want to access the tables after the load I get the error message that accessing the table is not possible at the moment - i have the set the integrity of the table first... I am now looking for a way to set the integrity for all tables at once after the loading of many tables. Is there a way to get this done? another question came just to my mind: is the a way of making the db2 CLP a little more comfortable. A command history would be graet for starters... Thanks for any help... Greetings, Jan      |
|
02-27-2008, 01:49 AM
| |||
| |||
| Re: set integrity after load "Jan Suchanek" <jan.suchanek@gmx.de> wrote in message news:415d69a7$1@news.uni-ulm.de... > > another question came just to my mind: is the a way of making the db2 > CLP a little more comfortable. A command history would be graet for > starters... > What version of DB2 are you using and what OS are you running? I'm running DB2 V7.2 on Windows XP and my DB2 CLP has a command history; just use up-arrow and down-arrow to cycle through them. I thought all recent versions of DB2 had that feature. (I know Version 2 did not have command history but I don't think many people are still running Version 2.) Rhino |
|
02-27-2008, 01:50 AM
| |||
| |||
| Re: set integrity after load hi, Rhino wrote: > "Jan Suchanek" <jan.suchanek@gmx.de> wrote in message > news:415d69a7$1@news.uni-ulm.de... > >>another question came just to my mind: is the a way of making the db2 >>CLP a little more comfortable. A command history would be graet for >>starters... >> > > What version of DB2 are you using and what OS are you running? I'm running > DB2 V7.2 on Windows XP and my DB2 CLP has a command history; just use > up-arrow and down-arrow to cycle through them. I thought all recent versions > of DB2 had that feature. (I know Version 2 did not have command history but > I don't think many people are still running Version 2.) We talking about a V8.1 - so it should work... But the up-arrow does not work. Has this feature to be activated? Greetings, Jan |
|
02-27-2008, 01:50 AM
| |||
| |||
| Re: set integrity after load Jan Suchanek wrote: > hi, > > Rhino wrote: > >> "Jan Suchanek" <jan.suchanek@gmx.de> wrote in message >> news:415d69a7$1@news.uni-ulm.de... >> >>> another question came just to my mind: is the a way of making the db2 >>> CLP a little more comfortable. A command history would be graet for >>> starters... >>> >> >> What version of DB2 are you using and what OS are you running? I'm >> running >> DB2 V7.2 on Windows XP and my DB2 CLP has a command history; just use >> up-arrow and down-arrow to cycle through them. I thought all recent >> versions >> of DB2 had that feature. (I know Version 2 did not have command >> history but >> I don't think many people are still running Version 2.) > > > We talking about a V8.1 - so it should work... But the up-arrow does not > work. Has this feature to be activated? > > Greetings, Jan > > I have observed the same problem with V7.2 and V8.1, but only on Linux and not on Win-NT/XP. On our Linux server, this is what the up-arrow gives: (inside the DB2 CLP; the history feature works fine in sh or csh): db2 => ^[[A Is there a DB2 environmental variable to be set, similar to TERM in the shell? N. Shamsundar University of Houston |
|
02-27-2008, 01:50 AM
| ||||
| ||||
| Re: set integrity after load > I have observed the same problem with V7.2 and V8.1, but only on Linux > and not on Win-NT/XP. > > On our Linux server, this is what the up-arrow gives: (inside the DB2 > CLP; the history feature works fine in sh or csh): > > db2 => ^[[A > > Is there a DB2 environmental variable to be set, similar to TERM in the > shell? > > N. Shamsundar > University of Houston The command history is function of windows (up or down arrow), not DB2. UNIX shells have there own version of command history. Try alt-k on UNIX (that is what I use on AIX). |
Linear Mode
