Search results

  1. S

    How to use protop?

    Silly me, I forgot to set the PROPATH variable. now it works fine. Thanks.
  2. S

    How to use protop?

    Thanks Tom for your replay, When i run that command I see only blank screen, thats why I got confused.
  3. S

    How to use protop?

    Hi, I am trying to use protop monitering tool, but i do not get any o/p. I gave the below command mpro <dbname> -p protop -param "i;10|d;Summary,User IO" It gets configured properly, when i type h it displays help, when i press m it does nothing. I am connecting the DB through Putty...
  4. S

    probkup question about error checking

    This will help you. probkup online <DBDIR>/<DBNAME> <BACKUPDIR>/<BACKDB> -com >> <BACKUPLOG> ERR=$? if [ "$ERR" != "0" ] then echo "Backup Err"|mailx -s "Backup Error" -a <logfile> <ur-mailid> fi
  5. S

    collation table

    Hi, I've to load _trans.df into the production database since there is some issue in report generation, do i need to do pro dump/load after updating collation table. please advice. Thanks
  6. S

    switching current working database.

    Hi, how to switch current workiin databases to another DB through progress code.
  7. S

    DB information

    Hi, Where is the information about the following stored in progress DB. 1. When was it created. 2. when was it refreshed. 3. df loaded. 4. D/L etc....
  8. S

    Statistics With Cross-reference (-yx)

    Hi, What is -yx parameter? How do we use that?
  9. S

    ERROR: Database -ID Not Defined in Gen Codes

    Hi, When im trying to run a code im gettin this err. please help.:confused:
  10. S

    Last open date mismatch

    Hi, Im getting the below err while starting the server. is there any way to get rid of this. please help me
  11. S

    Database status

    Hi, Is there anyway to find whether a database is up or down. i want to prepare a list of DBs which are running.
  12. S

    SYSTEM ERROR: read wrong dbkey at offset 948199424 ....

    My DB got down suddenly, when i checked the log file, below was the err. could anyone explain me what is the err and how can i rectify that. 18:32:04 Usr 2: SYSTEM ERROR: read wrong dbkey at offset 948199424 in file / dbs/db06/chn/cfac/cfacprtfq_35.d3 found 0, expected 23791680, retrying...
  13. S

    deleteing primary index

    Hi, How to delete a primary index and also please let me know if we can edit the index fields.
  14. S

    DB gets down automatically

    Please find the log file details (user JSARAVA4 is trying to load the data) . . 15:53:47 Usr 5: Login by jsarava4 on /dev/pts/34. (452) 16:02:12 Usr 5: KILL signal received. (298) 16:02:12 Usr 5: Begin transaction backout. (2252) 16:02:12 Usr 5: Transaction backout completed. (2253) . ...
  15. S

    DB gets down automatically

    Hi, when i try to load a bulk amt of data through CIM file, my DB automatically gets down. could anyone explain me the reason?
  16. S

    emptying all the tables in a database

    Hi, i want to keep only the schema in a database, is there anyway to delete the content of all the tables in that database.
  17. S

    incremental DF

    Hi Everyone, I have two tables(with same name) in two different databases. is it possible to find out the difference between these two tables and get a incremental DF.
  18. S

    Server Parameters

    Hi, can anyone please tell me what the purpuse of each parameter below is -cpinternal 620-2533 -cpstream 620-2533 -cpcoll thai-old -cprcodein 620-2533 -L 1000000 -c 250 -Ma 3 -Mn 1 -spin 50 -semsets 1 -n 70 and is that optimum for around 25 users, please advice how i can modify the values...
  19. S

    increase -n on the server

    Hi, im getting below err while trying to connect to the server You have attempted to connect to a database with too many users connected to it. Retry the connection later, or increase -n on the server. (5291) the below is the content of my .pf file -cpinternal 620-2533 -cpstream 620-2533...
Top