Wednesday, December 25, 2013

.df or .d apply (definition structure) on Database

How to apply .df  or .d on Database


DF apply on Database isn't a difficult task, but if you apply wrong DF on wrong database it'll be a little headache for you!!!

".df" file is data definitions. This contains the definitions of tables, indexes and fields. Not the data inside of them. Typically you would load a .df file in order to create a new table or to add fields and indexes to an existing table.

Care to be taken on DF apply,
  1. confirm on which database it should be applied.
  2. make a note of the path where it is exactly.
  3. ensure that no users are currently using the database (but never apply in single user mode).
  4. get a proper downtime before apply.
  5. ensure all the areas are present in the database.

As soon the downtime please down the database and start it with buffer of 10000 or more login with your credential to the Database, go to data dictionary

How to goto Data Dictionary mode
  1. mpro <db-name>
    • hit F3 goto tools>Data dictionary.
  2. mpro <db-name> -p dict.p
once you go to Data dictionary
  1. go to admin > load data and definition > Data Definition (.df)
    • enter the full path of the .df file unless if it present in same directory where DB exist.
    • check mark the stop on error field Press F1
    • wait till it shows load is completed.
you are done with the .df load


How to apply .d

These files contain data that has been exported from one database which you then want to import into another database.
.d is also same way to be apply.

only difference is 
  1. go to admin > load data and definition > Table contents (.d)
    • enter the full path of the .d file unless if it present in same directory where DB exist.
    • check mark the stop on error field Press F1
    • wait till it shows load is completed.
You are done with the loading of .d

How to Create Database


Database is a structured set of data held in a computer, esp. one that is accessible in various ways. 
We can create DB in progress using different methods,
1.     Creating DB with structure file (.st)
2.     Creating DB with copy of other existing DB
3.     Restoring from a backed up DB
4.     creates a new database from a specified source database.

1. Creating DB with structure file (.st)
To create DB with structure file we need to know what exactly the Structure file means. Structure file is text file with .st extension, which contains the structure of Database.

What are the contents of .st file?
.st file mainly containing below details
·        The storage area type : indicates type of area ( a- after image, b- before image, t-transaction log, d- data are)
·        The area name : name of the storage area
·        The area number: Number of storage area (you can give number above 6 , till 6 will be default used by progress, if you did not give number prostrct will automatically give number).
·        The records per block : optional field numbers of records should be in a block (20 - 27) 
·        The number of blocks per cluster : optional field and this is for type2 area number of blocks per cluster values can be 1 8 64 512
·        The extent pathname: the path of extent where it stores physically.
·        The extent type: type of extent, variable(v) or fixed (f).

·        The extent size: size of fixed extent till when it can grow.



Sample .st file
b tests/largedb.b1 f 1048576
b tests/largedb.b2
#
a tests/largedb.a1 f 2097152
# SCHEMA AREA with a fixed length file of 3GB and a variable length file with
# a maximum size of 3GB.
#
d “Schema Area”:6,64 tests/largedb.d1 f 3145728
d “Schema Area”:6,64 tests/largedb.d2

Create Database with structure file

prostrct create <dbname> stfile.st –blocksize [1024|2048|4096| 8192] 


the above command will create void database to make it an empty database you have to copy the empty database to this.
In $DLC you can get the proper empty database if it is 1k blocksize DB name is empty, if it is 4k Db name is empty4. By default in openedge prostrct will create a DB of 8K blocksize. You can use below command to make void 8k Db to empty 8k DB
procopy $DLC/empty8 <db-name>


Creating DB with copy of other existing DB

If you want to have the copy of other database you can use procopy <source-db> <dest-db> your new Db will be created.


Restoring from a backed up DB

If you have a backep up database using probkup utility you can restore it by prorest command but you need to have .st file for this .

prorest dbname <dbname>.bkp

optionally you can use restore list
prorest dbname <dbname>.bkp < restore.list

if you are restoring on top of an existing db add "y" as the first line of restore.list.


Thursday, December 19, 2013

Progress Openedge Installation

Installation of Progress Database



Installation of progress open-edge will be very easy if you know what exactly you are doing, where the installation files are, where you want to install this, which application will be using this, where exactly Apache java are installed.

You should have root access to install Progress in UNIX like machines, log in to server and switch to root user, you always should be in /tmp directory to install the progress Openedge.

~#cd /tmp
/tmp#/installation/path/directory/proinst

when you hit above command you will be directed to below screen where it check the JVM and lets you select the required version.
It is must that JVM should be installed in your machine where you going to install progress Open-edge, usually progress consultants will always prefer java 1.5
you can check which java version is installed in your PC by hitting command java -version.



press y and hit enter you will be directed to next window.

Welcome screen of installation.
hope you agree for the copyrights hit enter.

you will be next directed to license screen where you have to insert the licenses.

information required are,

  1. company name (which is owning the license)
  2. serial number
  3. control number


you can enter multiple licenses by hitting Enter company name will remain same serial and control number will varies.once you done with entering all the licenses hit ctrl + E. it will prompt you to ask whether you have done entering all the licences hit y.


Next screen which appears is below.
OpenEdge Explorer functionality is provided within the browser interface for the OpenEdge Management.
When the AdminServer is running, a web browser such as Internet Explorer or FireFox may be directed to http://localhost:9090 (the default location of the OpenEdge Management / Explorer connection).
hit y if you have installed openedge app svr enterprise license.

if you hit Y you will be directed to below screen

Here you have to give JAVAHOME path which will be $JAVA_HOME environment variable. hit enter to next screen.

below screen will ask 3 important things,

  1. Type of installation
    • complete install
    • custom install    select complete install which will install all the package which comes under it.
  2. Destination path name
    • Here you have to put destination of the openedge which will be $DLC and work directory destination.
  3. Management Path name
    • here you have to put the management path and work directory management.


Once you complete entering all the directory hit enter when marker is on continue with installation.


Next screen will be Sonic ESB installation.
Sonic ESB is an enterprise service bus (ESB) which simplifies the integration and flexible reuse of business components using a standards-based, service-oriented architecture (SOA). Sonic ESB connects, mediates, and controls services, wherever they are deployed and eliminates hard-wired service dependencies. Sonic ESB provides fast, dependable and secure communications and transactional fail over of service interactions. Sonic ESB operates across domains, physical networks, and corporate boundaries.

We dont need it in standard installation hit n.

next screen which appears is

It allows you to build applications that use HTML, XML, WML, DHTML, and  most other mark-up languages (MLs) as the user interface.

hit y enter to next screen where you need to provide some configuration for webspeed.
this screen will asks for 3 steps

  1. Type of webspeed
    • sun webserver
    • CGI -compatible  (always prefer this apache needs CGI compatible works on all machine)
  2. Select web-server script directory
    • enter the cgi-bin directory path of apache directory
    • /path/to/apache2/cgi-bin
  3. copy static HTML
    • enter the same path which you have mentioned above.
continue with installation hit enter.

next section will be language selection section. hit enter to select and enter to proceed next screen, you can select as many language you want.

After that next screen which appears is settings for languages.
  1. character setting, collation, case setting
    • select American,united states,IS08859-1,basic,basic (if you selected English -American in prev screen)
  2. select date format (according to your company standard).
  3. select number format (according to your company standard).
continue with installation.


Webspeed adapter URL you can change if you want.
hit enter to next screen.


you can hit y only if you need it if not press N,
you can also enable it once complete the installation also.


Here comes the screen before installation which will brief your product details which you going to install
hit y to proceed.



once installation completes below screen will appear.
hit enter


this will be last screen of installation. enjoy the facilities of progress openedge.

Monday, December 16, 2013

Importance of Progress Database and Administration


           
                  Progress DB is one of the oldest and legacy Databases. The number of companies using this Database may be less but the data handled by progress is extremely huge. I am working as a Progress DBA since April 2013, i am working in Progress Openedge 10.2B so whatever the information i provide here will be applicable to this and higher version of DB. Here I can share you the importance of Progress DB related stuffs.


Progress Database Key Capabilities:
  • Supports 32-bit systems and 64-bit addressable systems as well
  • Compatible ODBC, JDBC, and ABL access to data
  • Java stored procedures supported by OpenEdge SQL
  • Large file support for 64-bit file addressing (requires OS enablement)
  • Support for 1,000 files per database storage area
  • Support for 32,000 storage areas per database
  • Support for 32,000 concurrent users
  • Support for tables of up to 9 quintillion rows
  • Databases can grow to 5 Exabyte
  • Support for up to 1 terabyte of memory

Available for:
  • HP-UX (PA-RISC) 64- and 32-bit
  • HP-UX Itanium2
  • IBM AIX Power PC 64-bit
  • Red Hat Linux
  • SuSE LINUX
  • Sun Solaris (SPARC) 64- and 32-bit
  • Windows