Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to create new database with my parameteres in GTM?

223 views
Skip to first unread message

lubomi...@gmail.com

unread,
Mar 31, 2017, 9:45:33 AM3/31/17
to
I'm new in GTM. I wanted to create new database file on GTM by means MUPIP application. (is it possible to create new database by means of MUMPIP or by GDE?)
I wanted to create new database by next script:

export regionName="TREE"
export dbFileName="/home/gtm/.fis-gtm/V6.3-000A_x86_64/g/tree/tree-gbl.dat"
export recordSize=4096
export keySize=1019
export globalBuffers=4000
export journalFileName="/home/gtm/.fis-gtm/V6.3-000A_x86_64/g/tree/tree.mjl"
export journalState="on"

$gtm_dist/mupip create -region=$regionName
$gtm_dist/mupip SET {-REGION $regionName|-FILE=$dbFileName|-Key_size=$keySize|-Record_size=$recordSize|-JOURNAL=$journalState,-jnlfile=$journalFileName}

Many errors are appeared. The main error is "/home/gtm/.fis-gtm/V6.3-000A_x86_64/g/tree/tree-gbl.dat" file or directory not found (directory really exists).

I know my approach is wrong, I do not know how to create a new database with the parameters that i need. In documentation I can't to find, how to do it.
Thank for your answers.

Lubomir

antoine...@gmail.com

unread,
Mar 31, 2017, 11:16:08 AM3/31/17
to


You should use a file that describe your schema first:

Paste the following in a file 'tree.schema':

======= CUT =====

D -R DEFAULT
D -S DEFAULT
T -S -Bloc=4096
T -S -Lock=40
T -S -Glob=4096
T -S -Alloc=1000
T -S -Ext=3000
T -S -Ac=BG
T -R -Rec=4096
T -R -Key=1019
T -R -N=NEVER
T -R -J=BE
A -S DEFAULT -F="tree-gbl.dat"
A -R DEFAULT -D=DEFAULT
LOC -R=DEFAULT
SH -R DEFAULT
V -A
E

======= CUT =====

Basically, this file destroy DEFAULT template, recreate the DEFAULT template with specific values. Recordsize 4096, keysize 1019...
Then create the segment DEFAULT and point it to tree.db file.
Make the DEFAULT Region to use the DEFAULT SEGMENT that points to tree.db.
Make that LOCK will be stored in the default region.

Then display the DEFAULT region.
Then verify, then exit.

This file should be sent to GDE then mupip:

shell> export gtm_dist=/opt/fis-gtm/V6.3-000A_x86_64/
shell> export gtmgbldir=tree.gld
shell> $gtm_dist/mumps -r ^GDE @tree.schema
shell> $gtm_dist/mupip create


The documentation is available in the Administrator guide and GDE command help.

Hope that it will give you enough hints to get you started.

http://tinco.pair.com/bhaskar/gtm/doc/books/ao/UNIX_manual/gdecmds.html

lubomi...@gmail.com

unread,
Apr 3, 2017, 10:05:08 AM4/3/17
to
Dne pátek 31. března 2017 15:45:33 UTC+2 lubomi...@gmail.com napsal(a):

lubomi...@gmail.com

unread,
Apr 3, 2017, 10:15:26 AM4/3/17
to
Thank you very much for your answer. All works fine. I created databases with my params, mapping .... etc all works OK.
I have still one question. Exists possibility how to turn off JOURNAL in routine code for one process only? (I can do it for all processes by means of mupip in region, but for all processes)

K.S. Bhaskar

unread,
Apr 3, 2017, 10:27:52 AM4/3/17
to
On Monday, April 3, 2017 at 10:15:26 AM UTC-4, lubomi...@gmail.com wrote:
> Thank you very much for your answer. All works fine. I created databases with my params, mapping .... etc all works OK.
> I have still one question. Exists possibility how to turn off JOURNAL in routine code for one process only? (I can do it for all processes by means of mupip in region, but for all processes)

Journaling is associated with a database region and determines recoverability for that region. You cannot turn it off just for one process.

Regards
-- Bhaskar

lubomi...@gmail.com

unread,
Apr 4, 2017, 2:36:54 AM4/4/17
to
Bhaskar thank you very much for your answer.
Exists some commercial support for FIS GTM? Is possible to report errors?
Best regards
Lubomir


K.S. Bhaskar

unread,
Apr 4, 2017, 10:21:55 AM4/4/17
to
For free support from the GT.M community, you can report bugs at https://sourceforge.net/p/fis-gtm/bugs/

I will write to you off-list about GT.M support on commercial terms. You can also write to me at bhaskar at finxact dot com.

Regards
-- Bhaskar
0 new messages