DBA Group

Use this group to associate any content which relates to database development and deployment, including performance, configuration, and testing and to ask questions which are not linked to specific content.


DataDigger

Anybody know how to set up/use datadigger? I've tried with the connection string in the readme.txt file and am getting an error.

I am new to OpenEdge and don't know much about any of their tools. I am very familiar with SQL and to some extent Oracle.

Error I'm getting is:
R-code file not located for "c:\datadigger\datadigger.p" (473)
** Unable to run startup procedure c:\datadigger\datadigger.p. (492)


Installation help

I am unable to get datadigger running.
I have no documentation other than the 3 lines contained in readme.txt
The error is:
R-code file not located for "c:\datadigger\datadigger.p" (473)
** Unable to run startup procedure c:\datadigger\datadigger.p. (492)

Here is my startup line pointing to prowin32.exe:
c:\IS21\Progress\bin\prowin32.exe -basekey "INI" -p c:\datadigger\DataDigger.p


can more CPU introduce performance issues?

I was talking to my managers about the new hardware configurations and I mentioned that for test like readprobe, more CPU can introduce issues,and I think everyone of them was holding their breath and thinking "what is this guy talking about?". but the fact is that more CPU don't always means better performance.


DBA jobs

It's obvious all of you have a lot of talent and skill when it comes to working with Openedge and Progress.
I'm currently searching for someone with your experience for a job opportunity I have available.
I'm here to connect you and your friends with opportunities to touch the technology love and make money doing it.
So if any of you are interested in taking a DBA job in Reston, VA or Canonsburg,PA the company is a $4 billion dollar company. They are growing fast and need someone ASAP.
I appreciate any advice you guys have on finding people.
Best wishes,
Ashley


testing with QA

One of the frustrating tasks can easily be the testing. When you are developer, you are asked to do the unit test and sometimes system testing, the full scaled test. It is a tricky thing in my opinion and here is why. When you are programing, you are confined within the parameters, usually the business requirement, things like with this rule with this condition, and those baselines, I need the program to produce this result or range of results. But when you are done, you are facing the whole another range of test, the system test.


The chronicle of performance tuning

In this particular place, now I look back and think back, in the span of two to three years, how the infrastructure has changed with performance tuning effort...


Network messages in Progress

one of the big factors I noticed when I was doing the test to move the users from the share-memory connect to the remote-client connect, was the network messages. I never paid close attention to how they are used or how big those messages(packets) are. In the test servers, after I moved the users to the frontends, the CPU on the database server didn't seem to drop at all, one thing I noticed was the system CPU was a lot higher than the user CPU in the vmstat output which was not what I wanted to see.


Database Performance

On a request from a client to decrease the numbers of extents on a database we restructured the database with larger extents using a new structured file. But now the client is complaining about database performance. Is really possible?

Errol


performance charts

I never use OE managment before, not sure if there is a web version and I think web version has an edge when it comes to monitoring. The first version of charts I built was on OFC(open flesh chart), it is a great open app. It has more updated version now, working more with JSON(if I remember it correctly). One thing I needed and it doens't have is the abablity to see the trends unless you draw it, that's something Google charts can provide. Have you ever noticed on the google finance charts, the annotatedtimeline chart.


DB Re-org and automation

The last project I was doing for this company was database reorganization, to remove the unwanted tables/extents/areas . The task was to get rid of the areas and free up the SAN space. First I went through the process the analysis of data see which table in which area; which way I should should move to make the whole thing more effective; after that, it is the process of testing which methods I should use to move the tables to different areas, table move or dump&load.


Ports

This will the summary of my experiences in last couple of years over ports in Progress (and AIX).


Memroy

Progress uses the buffer pool which is the single largest memory usage by the database engine. Other than that, the 102B user each uses around 30M of memory. So for 1000 users, the system will use about 4G of memory and that is not a lot. The VST stats are part of the memory, they go away when you shutdown the database. VST has many parts, so if you are not careful, they might bite you when you least expected.


LRU skip

In the 102B06 release, one of the most beneficial improvements is the LRU skip.


help with name server ..

How can i get the server's name on wich I'm working ... I'm using a GUI application and it's connected to a linux server with a .ini and .pf file ..

does anybody know some code for get this??? I have tried with DB-REMOTE-HOST but it didn't work ...


Word and Excel Utils

I tried to user the program "slibxlsx" from library slibooxml an I received the messaje:
This copy of slibxlsx.p has expired.
I mention that I use OpenEdge 10.2B on Linux.

I called this library because I had an error "COM objects not implemented on this system (5676)" when I tried to create an excel file from Progress.


#
Syndicate content