Search results

Hi, How can I give permissions to an specific user to disconnect users? User cronman cannot disconnect user caroline. (2258) Thanks indeed. Kind regards, rrojo7229

Hi, We work with a Third software,so our development it is quite limited. We have around 20 branches where it runs Batch programs at night. But if someone leaves the screen opened in a Maintenance screen ,that could lock the table. So, at night the Batch program fails for...

Hi, Someone has idea how can I run a program which connects several databases but they do have different Metta-Schemma. I mean, the databases are in different versions, so it is asking for recompilation. I tried to run in Source Code just without any compilation but still giving the...

Hi, Is there some way to startup more servers increasing -Mn parameter (-n parameter) but "Online"? I saying that thing because the DB can not be shutdown to take the new values for Startup parameters, during the day at rushing times. Progress 9.1E - RedHat Linux 3 Kind Regards,

Hi, No, this table is not a separate area, it is in the same area where all the tables are: "Schema Area". Kind regards,

Hi, Could you tell me please, which is the quickest way to blow up a table which has around 64 million records? - Delete table or make a delete by record - (using for each) with -i (Crash Recovery option DISABLED) in the proserve? Regards,

Now I added a score for this issue. Regards,

Hi Andrew, That works great.... You have saved a coleague from Ireland, Dublin... Thank you very much... Good Stuff. Kind regards,

Hi , Could you give a help how can I do that using Dinamic Queries? I know that should work for "where" clausule but Does it works for different indexes, too? 1) FOR EACH sltran WHERE sltran.co-code = ledger.co-code AND sltran.ledger-code = ledger.ledger-code AND sltran.doc-date GE...

Hi, Could you to guide me how can I built a code but applying variable values to &GLOBAL-DEFINE? As far I understood &GLOBAL-DEFINE works in a Static concept but why this peace of code works? /*** Works OK *****/ def var yvar as int . def var zvar as int. def var vdepo as int. def var...

Hi Casper, Thank you for your quickly reply. Actually, when the last BI variable got the Limit LINUX Size it was written these ERROR MESSAGES at log: 00:52:05 SYSTEM ERROR: Attempted to exceed maximum size on file /archive/bifiles/package.b3. (9452) 00:52:05 ** Insufficient disk space...

Hi, Please, could you give a tip? Database is not starting UP...despite is not writing any ERROR message at database.lg. The BI reached the limit last night and this morning the DB was shutdown and was added new BI Files. But now when we try Startup the DB - keep hanging up in...

Hi Tom, I am trying to improve the speed for idxbuild and my last turn was adding "-i" to try minimize the writing notes in the BI's, but this way below it was not show any alert message like "-i - no integrity" or something like that. Am I making something wrong? proutil package -C...

Hi Tom, It is posted here the results for dbrpr and idxbuild but neither did not show any problem. proutil package -C idxbuild ALL -TB 24 -TM 32 -B 1000 -SG 64 1940 indexes rebuilt Index rebuild complete. 0 error(s) encountered. (1644) proutil package -C dbrpr < dbrpr.inp >...

Hi Tom, Thanks for your quickly reply. It is not Code Page wrong issue, this problem has started after some Energy Failure at the branch where is this Database. The lg file has been shown this ERROR messages: SYSTEM ERROR: bfposto: position timestamp - 233013 - doesn't match the...

Hi, We have a database with bad/corrupted records like this: Dep Code Prod ──────── ─────── }èM37│ ØÉ"l╠ *ièXdÓ┬ 100008 100206 100222 100347 I am wondering which is the quickiest and safest way to remove these...

Re: Can I speed up Idxbuild adding -i parameter? Hi Tom, Yeap, I made a confusion... You are right, I was refering about -i. So, if at the end I see as Proutil idxbuild results: Index rebuild complete. 0 error(s) encountered. (1644) I don't have to be worried. Do I...

Hi lads, Someone knows could it bring some DB damages if I added -bi (disabling Before Image) at Proutil command? proutil <dbname> -C idxbuild all -bi -TB 24 -TM 32 -B 1000 -SG 64 Progress 9.1E Linux RedHat 3 Kind Regards, rrojo7229

Hi Ok, Yeah, the things are more clear now to me. Thanks for the BrainStorm, it was very handly. Thanks indeed for your help Tamhas and Casper. Kind Regards, Ricardo Olguin

Hi Tamhas, Yes, we do have 25 people per branch not 25 simultaneous users. So, you mean make the upgrade first to 10.1B before try SQL Client? But to access the Progress Database using PHP I need just SQL Client, nothing more? Thanks, Kind Regards, Ricardo Olguin