Search results

Hi, One of our development DB was restarted with -F option. Now every time we see a warning. How to get rid of this warning without rebuilding all the indexes. Thanks

Hi, Pentaho Report Designer 3.9.0-GA 15557, Openedge 10.1C The following query throws error (shown after query) : select ptho_agtsals.agentid, ptho_agtsals.agentname, ptho_agtsals.grosssales, ptho_agtsals.repyear, ptho_agtsals..repmonth where...

Thanks Cringer & Rob. Rob, what I meant is they dont use share memory directly and you are correct it is a remote connection. Below is the copy of .lg file. [2012/03/08@18:04:25.334+0000] P-70112 T-1 I BROKER 0: (8527) Storage object cache size (-omsize): 1024...

Hi DBAs, Openedge 10.1c, AIX 5.x, In one of our production database the maximum servers allocated are 100. At any given point in time our concurrent user count does not exceed 120 which includes batch processes. Ours is a GUI application and users does not login in remotely, unless for batch...

Thanks Cringer. The browser is not directly updated. Records are selected and right clicked, a procedure runs which does the validations and updates the fiields with some constant values and these changes are imiidietly visible. How to achieve this? TIA

Hi All, Progress 10.1c, Prgress 4GL in-built application and RH linux. I have an editable browser with records from a table displayed to the user. The requirment is that the user selects few records, lets assume 4, right clicks to run a procedure that changes some fields. These changes should...

A bit of advise on RAID 5. NEVER "EVER" MIGRATE A DATABASE TO RAID 5 OR RAID 6. Few months back, I tried to do migrate a V9.1e DB on redhat to V10.2b on Redhat with RAID 5. It took entire week just to binary dump data of around 50 GB. Unless it is read only, datawarehouse or a reporting server...

Hi All, Progress 10.1c, Redhat 5, windows xp client. I am trying to connect to admin server on linux from windows xp cleint. I can ping/telnet the linux server and ther is no firewall / iptables on the server. When I try connecting admin server on linux from windows it shows error "invalid...

Thanks both of you for good piece of advice. Which parameter in ubroker.properties is used to set the synchronous bit? Thanks again.

Hi, Any one supporting an OLTP application on 4GL appserver or webspeed, please let me know : 1. Type of remote procedure ie synchronous or asynchronous 2. Appserver session mode settings such as session managed or session free and which type ie state-free, state-reset, and when to use which...

Hi all, In Promon, R&D Activity, BI Log, apart from all metrics there is an "busy buffer waits" and "empty buffer waits". Can any one be kind enough to explain the difference between these two, since at the outset they appear to be the same. Thanks in advance.

Hi, One of the field in a table contains arrays. How to view / export data of this field using SQL or Java client ( SQL explorer for example). TIA

Hi all, I have a problem displaying "n" number of decimals in my SQL client application. Example, original value in database (9.1e) is 123.123456789 but the value in SQL client application is 123.1234567. Any ideal how to display the full length? Thanks in advance.

The same thing happened with me when I converted a Progress 9.1e DB to 10.2B using Proutil utility. Upon investigating, I found that the 'host name' of the Linux box was more than 50 characters. We reduced the sized and it worked.

Thanks Tom. I enquired about the IOs during peak hours and it is roughly between 80 & 100 IO/sec. I just need a rough estimate of minimum disks we should club for the above environment whithout casuing any performance issues. I read in a 'whitepaper' some wherre that says 10 disk will give...

Experts, What is the recommended number of hard disks to implement RAID 10 for database of around 150 GB, nearly 200 concurrent users on a redhat box, an inhouse developed webspeed application(OLTP) and a BI tool. Thanks

Hi experts, Progress 9.1e, Redhat, SQL explorer. Urgent help needed to run below SQL & PL/SQL queries in SQL explorer. 1. Description : To Know total row count from statistics available (with out running count(*) from that table) SQL Statement : SELECT num_rows FROM all_tables WHERE...

Thanks Tamhas. But this client uses JDBC to login and want to create tables & indexes and does not want to use Progress tools. Any ideas, if any one has ever created indexes using JDBC client on Progress 9.1e. TIA

Hi, I am connecting a Progress 9.1e database through Sql explorer. I created a table using SQl but unable to create an index. What is the exact syntax to create index on a table using SQL-92. Thanks in advance.

But I dont see the metaschema tables such as _file here. Is there a way to run a query against these tables