Search results

Hi all, I like to install 10.2A on a windows 2000 computer. 10.2A needs .NET 3.x, but .NET 3.x is not avail for w2k. I do not want to use the .NET UI, but like to have the newest version of the OE Architect. Is there a way to overcome the preliminary .NET to install 10.2A on w2k? Thanks Klaus

Hello pinne65, you can use the following method. - create all new storage areas - create a new table as a copy of the old one, e.g. "cust_new" for "cust" in the new area - Do a for each loop with buffer copy (do 50 copies in one transaction) - Drop the old table or rename them to "cust_old" -...

Hello rob1, I've done various individual training regarding db administration or programming, both in German or English. GB is not far for me... Regards Klaus www.iap.de

Hello Ricardo, in our case we had HACMP from AIX. I believe there it is normal, that the scripts wait until the shutdown is ready. Therefore I can not tell you about Red Hat Cluster solution. But I wouldn't worry, when I need to increase some timeouts if it's looking appropiate to me. Klaus

Hello Ricardo, you should have two different szenarios in your cluster. 1) Normal takeover This is started by a user or whatever, but is a planned takeover. In this case the node 1 will get enough time to shut down everything. After shutdown node 2 will come up, get shared resources like disks...

We use a function in a script. See below. function f_RemoveLkFile { # $1 = Directory # $2 = lk file name fuser $1/* 2>/dev/null | read FUse_test 2>&1 | tee -a $LogFile if [[ -n $FUse_test ]] then echo "" | tee -a $LogFile echo...

We migrated to 10.1b, 64 Bit on AIX. The programs are slower after that :( I know the 64 bit r-code is faster. How can I see, if the compiler is correctly generating 64 bit r-code? I'am not sure if the 64 bit version can run 32 bit r-code. If not, the answer is clear. Klaus

Hello Jaya, the file names have changed. See documentation Book: OpenEdge® Data Management: SQL Development Chapter: JDBC Client "The JDBC architecture consists of several files. The JDBC driver includes the openedge.jar, util.jar, base.jar, pool.jar, and spy.jar files. Table 2–1 lists the...

Hello Admins, there is the -noint64 startup parameter in OE 10.1B. This parameter has the effect that int64 is handled like int(32). But we like to have the opposite, we like to have all int in our programs handled like int64 without changing the source. In the past there had been secret...

Hello customprogress, maybe it's easy. Your file should contain one line for every backup file, something like: /db_save/yourdb-20061220.sav002 /db_save/yourdb-20061220.sav003 /db_save/yourdb-20061220.sav004 In this case you can have up to 4 files, one from the command line and 3 from the...

That is also easy. Change the names in a second database, connect both dbs and create a so called delta.df with the Data Administration. It will ask you, if you want to rename the table. Best Regards Klaus

For clearing poor performance on a db machine, I like to find out how much the system is waiting for the disk to answer request. Under Unix I can easily use vmstat or nmon to see the "wait for io". How can I see this under NT Server? Regards Klaus

We had a similar problem with V9, AIX. The reason was a seldom error related to Private Buffers on self servicing clients (-Bp). You should call Progress support and collect your logfiles and any coredump.

You need to pay for that. That may not be a problem, but it - take time - it's not nice to say at audience A "go to audience B, they are able to help you"

Hello Tom, thanks for your suggestions. Was at the PTW, so my answer is late :) Did this already. I do not believe that Progress will forgot the old indexes if you recreate the table. That was one of our ideas, but although the other stuff is small, the indexmove will take long, because of...

Hello Tom, I can not drop them. The table is tool large, the drop will take more than a whole weekend. To work around this problem, we replicated the table. Then I truncated the old table area, but I can not truncate the index area, because there are other indexes in that area. Regards Klaus

Progress 9.1E03, AIX, Enterprise db I truncated an area with one table and therefore the indexe become inactive. I now want to idxfix the indexes to reclaim the space which is now used by the indexes. I started proutil MyDB -C idxfix | tee idxfix.log Then I selected one index in the table and...