DBMS Server for batch jobs

From: Graham Parsons 

In article: <324271A7.74BD@ci.unil.ch>  Mauro Stevanin 
 writes:

> Hello,
> 
> I'd like to create a DBMS to perform only jobs in batch. All on line 
> connections should be executed by DBMS-A and all batch connection 
> should be executed by DBMS-batch which should have a lower priority.
> 
> How can I link a job batch to a specific DBMS ?
> 
> Any suggestion will be appreciated.
> 
> Mauro Stevanin
> University of Lausanne - Switzerland
> Mauro.Stevanin@ci.unil.ch
-- 

Mauro,

What you need to do is run the batch server as a private server 
(-nonames DBMS option) and set the environment variable II_DBMS_SERVER 
to point to this server within the batch job stream.

The DBA and IO manual give you full descriptions on both of these 
objects.

N.B. - remember if the servers are to access the same database, they 
will be using the same shared cache and therefore the tuning parameters 
corresponding to the cache must be identical in both servers.

+--------------------------------+-------------------------------------+
|  Graham Parsons		 |  email : graham@fcltd.demon.co.uk   | 
|  Principal Ingres Consultant	 |  tel.  : 0973 231804                |
+--------------------------------+-------------------------------------+
|  Forest Consulting Limited                                           |
|  Relational Database Consultancy                                     |
|  London, UK		               				       |
+----------------------------------------------------------------------+


From: martinm@131.242.113.190 (Siggy Smith)
Subject: Re: Server only for jobs batch

This is what I have done on one of our production databases (v6.4).

1) Create a new server class
     -edit the $II_SYSTEM/ingres/files/name/iiname.all
     and add the new server class eg
     myserver  local  transient

2) restart ingres and crank up your new DBMS server for batch 
    processing

3) in IINAMU type the following line
    ADD myserver *  

    where  is shown when you start up the new
    DBMS server

4) to connect to this server class do
     - sql mydb/myserver

I hope this helps you. 

Be careful with low-priority batch servers (eg dont have any updating
- will cause the higher priority servers to queue for the low priority
server).

Michael Martin
Ingres DBA
Department of Natural Resources
Qld
Australia
 

From: Roy Hann 


Yes; see sections 09.005, 09.006 and 09.018 of the Ingres FAQ (/pub/ingres
on ftp.naiua.org) for the mechanical details, especially 09.018. 

I would not automatically assume that it is a good idea to run the "batch" 
server at reduced priority.  You should do some careful testing to see if
that is really beneficial or whether it is in fact harmful. 

========================================================================
Roy Hann                                   rhann@tnc.com
BKB Engineering Ltd.,                      NAIUA Member
11211-76th Avenue,                 
Edmonton, Alberta                          http://www.tnc.com/bkb
T6G 0K2                                    Tel: (403)497-2409
Canada                                     FAX: (403)436-6055
========================================================================

From: "Colin.MacKellar" 
 
 Hi Mauro,
 
 We do this using server class names in 6.4, I have not ported this to 
 OpenIngres yet.  Edit ... /files/name/iiname.all to create a new name 
 class like batch, like this:
 
 INGRES          local   transient
 BATCH           local   transient
 MAINT           local   transient
 ONLINE          local   transient
 COMSVR          local   transient
 ALB             local   transient
 STAR            local   transient
 NODE            global
 LOGIN           global
 LTICKET         local
 RTICKET         local
 
 This example creates a maint and online class as well.   After your 
 next name server restart, you will be able to register servers in the 
 new class like this:
 
 IINAMU> add batch * 
 
 The asterix can be a list of DBs instead.  Once a server is registered 
 in the new class you access it by appending a slash and the server 
 class name to the DB name, e.g.
 
 sql iidbdb/batch
 
 I'd be happy to help if you need more details.
 
 Colin.
 
 +------------------------------------+-------------------------+
 | Colin MacKellar                    |  Database Manager       |
 +------------------------------------+  Perot Systems Europe   |
 | Tel  +44 (0)115 966 2177           |  398 Coppice Road       |
 | Fax  +44 (0)115 966 2091           |  Arnold                 |
 | E-mail Colin.MacKellar@ps.net      |  Nottingham     NG5 7HX |
 +------------------------------------+-------------------------+



Mu Mu Aye wrote:
>  
> We've just installed OpenINGRES 2.0 (Alpha Unix).
> Current Ingres 6.4/05 version, we start 2 servers (rundbms.opt and
> batch.opt). Then through 'iinamu' the second server is added as batch
> server that is mainly used to run all the batch jobs.
>
> Please help me.

If you did this in 6.4 as a load balancing method, or to take advantage of
multiple CPU's, consider NOT using a separate batch server under OI 2.0.
Alpha/unix is an OS threads platform, meaning that each session is its
own thread and Unix does the scheduling instead of Ingres.

If you need the batch server class around until you can transition your batch
jobs, run cbf, duplicate the DBMS server configuration, Configure that
duplicate, and edit the server class.  Don't forget to change the startup
count on the duplicate.
 
Karl
Ingres Q & A
To William's Home Page
Email William