Archivo del Autor: carlosap

converting database from mysql to mongoDb

http://www.mongovue.com  MongoVUE is an innovative MongoDB desktop application for Windows OS that gives you an elegant and highly usable GUI interface to work with MongoDB. Now there is one less worry in managing your web-scale data.     is there any easy way to change the database from mysql to mongoDB ? Method #1: export… Leer más »

You must dump & load in order to reconfigure to type 2 storage. Type II storage areas —  for data, for indexes and  LOBs , if you have any word indexes put those in their own storage area also. NOTHING EXCEPT SCHEMA should be in the schema area. In order for an area to be… Leer más »

Overall performance of the databases decreases

Printable View INFORMATION Article Number 000012531 Environment Progress 9.x OpenEdge 10.x IBM AIX UNIX Enterprise Database License OpenEdge Category: Configuration OpenEdge Category: Database OpenEdge Database Category: Monitoring/Promon OpenEdge Database Category: Performance Question/Problem Description Database hanging periodically Overall performance of the databases decreases It takes a long time to login in the application when users already… Leer más »

How to increase or modify java heap size for the Admin Server in OpenEdge ?

http://knowledgebase.progress.com/articles/Article/P99089?popup=true   Article Number 000022572 Environment All Supported Operating Systems OpenEdge 10.x, 11.x OpenEdge Server Technology Category: AdminServer Question/Problem Description How to increase or modify java heap size for the Admin Server in OpenEdge ? How to increase java memory for Admin Server in OpenEdge? How to set the JVMARGS in Release 10? How to… Leer más »

JAVA-LANG Nullpointer Exeption on starting database agent after installing 10.2B SP6

Article Number 000034388 Environment OpenEdge 10.2B06 OpenEdge 11.1 Question/Problem Description JAVA-LANG Nullpointer Exeption on starting database agent after installing 10.2B SP6 The database is started and can be connected to OpenEdge Explorer shows the database as not running Clarifying Information Database Agent started without issues in 10.2B05 Only databases with a specific servergroup defined fail… Leer más »

How to revoke SQL privileges of the Default DBA and hide sysdbauth and systabauth from public?

Resolution To create a SQL DBA and hide all Progress Schema tables and views from the public do the following: PRECAUTIONS: A.  Take a backup of the database prior to making any changes. B.  Test on a copy or test database prior to making changes to the Production database. 1.  Enable the SYSPROGRESS sql DBA by registering/adding  the user SYSPROGRESS via the 4GL… Leer más »

Optimize Apache and MySQL for a 256MB VPS

Home > Misc. Tutorial Logs > Optimize Apache and MySQL for a 256MB VPS « Newer | Older » Optimize Apache and MySQL for a 256MB VPS September 1, 2011 No Comments Tags: apache mysqltuner prefork ubuntu vps For small websites or not so popular WordPress blogs a small VPS with only 256MB of RAM… Leer más »

odbc locks connection progress

Hi All, We are connecting to the Progress Database from ASP.NET web application using the Progress ODBC Driver. The isolation Level is set to READ COMMITTED IN THE Driver Properties. We are trying to retreive the data based on certain conditions from one of the web pages. However, if the record is locked in Progress… Leer más »

How to configure the SQuirreL SQL Client to connect to OpenEdge 9.1E, 10.1A, 10.1B, 10.1C, 10.2A, 10.2B, 11.0, 11.1, 11.2 or 11.3

Nota al final añadir: – append defaultSchema=pub to the end of the URL. Like: jdbc:datadirect:openedge://localhost:5555;databaseName=testdb;defaultSchema=pub http://knowledgebase.progress.com/articles/Article/000032547   Resolution First download the installer file squirrel-sql-<version>-install.jar from http://squirrel-sql.sourceforge.net and install the SQuirreL SQL Client under Windows or Linux using the command: java -jar squirrel-sql-<version>-install.jar During the graphical installation an installation path will be asked, as well as if a base or a… Leer más »