Search results

  1. G

    how to check performance?

    Hi, Yo can find it - in your database log file (.lg) after multi-session begin message or - in promon go to Database Status (7) Regards, Gabor
  2. G

    Listview with Large icons

    Hi, I made a small test program and I could make similar effect though the scroll-bar appeared in small icon mode. I changed the Arrange attribute to 2 (IvwAutoTop) and the problem disappeared. Can you try that? Note: I used ListView Version 5 SP2. Best regards, Gabor
  3. G

    text indexing system

    Hi, There is a built-in word indexing feature in Progress so you do not need to use external searching application. Fields having word index you can use CONTAINS operator as written below: select * from table1 where field1 contains "he" or select * from table1 where field1 contains...
  4. G

    Listview with Large icons

    Hi, Have you checked width-pixels and virtual-width-pixels of your frame? If not can you check it before and after your icon selection? It can lead to the mentioned effect. We had similar problem (not with Tree ActiveX) and setting virtual-width-pixels equal to width-pixels could help...
  5. G

    how to display 2 fields w/ the same names (same database but different tables)???

    Hi, Have you tried to use LABEL option like select table1.description label "des1", table2.description label "des2" from table1, table2 ... ? It works in Data Dictionary. Regards, Gabor
  6. G

    how to check performance?

    Hi, Before furher studying I recommend to start 1 BIW and n APW processes (where n is the number of disks used for you DB + 1) Have you set -spin start-up parameter? What is you BI block and cluster size? Strange thing is your Record Reads are closely to Record Locks, so it seems no-lock...
  7. G

    Umlauts and Streams

    Hi, What is your DB codepage? What is you start-up parameters (cpcoll, cpstream, cpinternal)? Are you using CONVERT [ TARGET target-code-page] [SOURCE source-code-page] in your OUTPUT TO statement? Regards, Gabor
  8. G

    Im spinning around

    Hi, Can you tell me the followings? - DB block size - DB size - Have you got self-service or remote clients - Output of # vmstat 5 command for 60 seconds period - Activity screen from promon (for 5 minutes) Regards, Gabor
  9. G

    Progress Database Administration

    Hi, You can allow blank users to access your tables editing their access rights. Go to Data Dictionary -> Admin-> Security -> Edit Data Security... -> here you can select your table and remove '!' from Can-read,Can-write,Can-Create,Can-delete fields. Other option can be dump and load...
  10. G

    Platform change

    Hi, We plan to move our application from HP-UX 10.20 to HP-UX 11. We have already installed V8.C17 on both machines. Since dump/load process takes about two days (estimated value) we would like to move the database to the new machine as it is. Taking KBase 11930 into account we have...
  11. G

    Licencing - Platform Change.

    Hi, We have a document called 'Progress Software Corporation Products and Policy'. We received it from Progress and it describes platform change policies. I think you should contact to your local Progress support to get the latest version. Once we have moved our RDBMS to new platform and...
  12. G

    vmstat and IO wait

    Hi, Since the problem already solved, I suggest to use sar command instead of vmstat next time (e.g. sar -P ALL 2 5). This can report per-processor statistics. Other option I can recommend is to upgrade to V4.3.3. Version 4.3.3 and later contains an enhancement to the method used to compute...
  13. G

    vmstat and IO wait

    Hi, In AIX 4.3.3 the wa column details CPU idle time (percent) with pending local disk I/O. If there is at least one outstanding I/O to a local disk when the wait process is running, the time is classified as "waiting on I/O". A wa value over 40 percent could indicate that the disk subsystem...
  14. G

    Performance problem

    Hi, Setting -spin is highly recommended. Good start is 2000. Adding -q to client start-up parameters is also a good idea. Resource waits seems to be OK. My questions are: 1. What is your DB block size? 2. What is your bi block size/cluster size? 3. Have you measured paging activity? 4...
  15. G

    Binary compatibility with HP-UX 11

    Hi, We plan to move our application from HP K-460 to HP L2000 server. We use V8.3B database server at this moment. Unfortunatelly the operating systems are differ, the old machine has HP-UX 10.xx and the new one has HP-UX 11. As I know HP-UX 11 can run 'old' binaries. Is there anybody having...
  16. G

    Displaying Version

    Hi Rick, The correct code is written below {&WINDOW-SYSTEM} was missing from it... Gabor DEF VAR l-dlc AS CHAR. DEF VAR l-version AS CHAR. l-dlc = OS-GETENV("DLC"). &IF "{&WINDOW-SYSTEM}" = "TTY" &THEN INPUT THROUGH VALUE(l-dlc + "/version" ) NO-ECHO. &ELSE INPUT FROM...
  17. G

    Displaying Version

    Hi Rick, This also shows your patch level. Regards, Gabor DEF VAR l-dlc AS CHAR. DEF VAR l-version AS CHAR. l-dlc = OS-GETENV("DLC"). &IF "" = "TTY" &THEN INPUT THROUGH VALUE(l-dlc + "/version" ) NO-ECHO. &ELSE INPUT FROM VALUE(l-dlc + "/version"). &ENDIF IMPORT...
  18. G

    Printing editor widgets

    Hi Talkers! We need a 4GL solution to print editor widgets in columns. Is there any solution? We need a result like the following: xxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyy xxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyy xxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyy xxxxxxxxx yyyyyyyyyyyyyyyyyyyyyyy where x and y...
  19. G

    Using the DLL for EasyLabel32

    Can you try the following? /******************************************************/ PROCEDURE LabelCommand EXTERNAL "c:\program files\tharo\easylabel 32\labelapi.dll": DEFINE INPUT PARAMETER Data as character. define return parameter retCode as long. END PROCEDURE. /* Label...
Back
Top