Search results

Progress Version: 11.6 Let's take an example, 1. I have an AREA with variable extent 2. I created couple of tables say 't1' (250MB size) and 't2' (350 MB size) 3. Take a backup of the db 4. Delete the table 't1' 5. Free chain analysis says '888 block(s) found in the free chain.'. Backup size...

@Rob Fitzpatrick - does sqlexp have any impact on AI/BI like how our FOR..EACH..DELETE do? - atleast a minimal impact or doesn't it use AI/BI at all? If it is removing the values from meta-schema and freeing up the blocks/chain, I guess the free space of that area will increase - right? How does...

Yes Tom, but as these tables are history tables (2 tables each of 100 GB) which is not used by our business anymore we wanted to get rid of these in 9.1E side itself and don't want these tables to be overhead during migration process where in we will have a downtime of 48 hrs. That's our idea on...

Got it @Rob Fitzpatrick. I will test DROP TABLE (SQL) and DELETE TABLE (ABL Data Dict) in 9.1E before testing FOR..EACH..DELETE.

Okay Rob, will test and get the statistics as you said before I do in PROD. How about removing the table entry and corresponding index entry from then VST? Will it disintegrate the table from Progress DB? Or will it still be part of our backup and restore?

What is the recommended way to delete a very large table without hampering the regular business operations? 1. DROP TABLE via DF script 2. FOR..EACH and DELETE records (all at once) 3. FOR..EACH and DELETE records (broken into smaller chunks like 10000 records per transaction) 4. PROUTIL...

Sure Rob.

@Rob Fitzpatrick I was about to ask you if this driver comes free or is a licensed one. The application that we are talking about is a 3rd party ERP application that gets details from our progress database and sends us the responses that would be required for the other workflows from progress...

Yes Rob, we have 2 different applications running on Progress; one is a very small application with hardly 100 GB of database size whereas the other one that am actively working on migrating is 2 .5 TB database. We wanted to get the 2.5 TB DB App migrated first, so that migrating wouldn't be...

Not right now, Rob. Out of curiosity - You mean the SQL queries that gets translated to Progress will have impact on index selection?

Thanks for confirming, Tom!

Did progress tighten their screws in picking index on new version? Intention of this question is as we are migrating from 9.1E to 11.6 will there be any difference saying 'Oh the same query picked index1 in 9.1E and picks index7 in 11.6'? I took a complete XREF of 9.1E and 11.6 and did...

We have an ERP system (running on Windows) that has to access Progress DB (running on Linux) with ODBC connection. Can someone provide me steps to configure ODBC drivers and provide me some sample connection strings? Does Progress Data Direct comes along with Enterprise version of OE 11.6 or do...

I was using Notepad++ or EditPlus but for last 6 months am using only Piew - I find this one really good. I'm facing one issue on this editor - when I start to write a .cls file syntax highlighting is fine but the moment I close the Piew editor and re-open all the syntax highlighting is gone...

@Rob Fitzpatrick - Awesome! Thanks for such a detailed explanation...

One more question, Are all other vst's part of PUB schema other than _sysdbauth and _systabauth? I raised this question because I quickly double checked my db analysis report and only the user created tables are PUB.table1, PUB.table2 etc. None of the VST's are with 'PUB.' RECORD BLOCK SUMMARY...

@Rob Fitzpatrick Good info! I wasn't aware that normal binary DL will not work on these tables as eventually as part of migration we will need to load the data from that table like how we do for _user table. Thanks Rob. To be honest I didn't know that it's not in PUB schema; do we have any...

I understand this question is of less importance but just noticed one thing when I was generating DF file for all tables including VST's; _sysdbauth & _systabauth doesn't get generated as part of DF even if it is selected. I used Data Dictionary > Tools > Data Administration > Admin > Dump Data...

Do we have any progress provided coding and db standards document/checklist? The coverage should have from low level stuffs like naming conventions, use of ASSIGN, use of NO-UNDO etc. I understand it's always debatable; but do we have one from PSC or may be from our progress experts.

@Rob Fitzpatrick - I could see articles that explains more from db migration perspective. Do we have any document that would outline the code issues that we might be facing during migration on any document; I couldn't find any. If we don't have any I will have to compile the code base against...