Skip navigation

This Question is Possibly Answered

1 "correct" answer available (4 pts)
4,949 Views 23 Replies Last post: Jun 24, 2009 1:42 AM by Jonathan Tai RSS 1 2 Previous Next
Govindaraj Contributor 13 posts since
Jun 8, 2009
Currently Being Moderated

Jun 8, 2009 11:55 PM

Mumps - intersystem cache server

Hi.

 

I am very new member to this openvista server community.

 

Can any one explain me how the .M files (i downloaded the Open vista server side code) related with Intersystem Cache server?

 

Where can i get the database scripts for openvista server? and How can i execute the DB scripts?

 

I would like to view the Database schemas and tables for openvista server.

 

 

Thanks and regards

Govindaraj

Jonathan Tai Medspherian 320 posts since
Jul 24, 2008
Currently Being Moderated
1. Jun 9, 2009 12:17 AM in response to: Govindaraj
Re: Mumps - intersystem cache server

The .m files contain MUMPS code.  This code is run on an interpreter; Cache is a MUMPS interpreter.  GT.M is another interpreter - one that is Free and Open Source (Cache is proprietary).  In MUMPS, the database is very closely tied with the language interpreter.  There is no separate SQL database.  So both Cache and GT.M are databases as well as MUMPS interpreters.

 

When you ask about database scripts, I'm assuming you're looking for an SQL database script that creates tables and loads data.  OpenVista is not built using SQL, so there's no "database script" to be had.

 

The DBMS OpenVista uses is called FileMan.  FileMan has a text-based interface that you can use to query the structure of it's files (the "data dictionary").

 

I hope that's enough to get you started.

Jonathan Tai Medspherian 320 posts since
Jul 24, 2008
Currently Being Moderated
3. Jun 9, 2009 6:55 AM in response to: Govindaraj
Re: Mumps - intersystem cache server

Instead of downloading the .m files (the -globals.zip), try downloading the -cache.zip file.  It contains a CACHE.DAT file that has the routines imported into it already.

Jonathan Tai Medspherian 320 posts since
Jul 24, 2008
Currently Being Moderated
5. Jun 10, 2009 8:31 AM in response to: Govindaraj
Re: Mumps - intersystem cache server

Assuming that you have created a namespace and mapped the routines and globals, you can dismount the .DAT file in the Cache System Management Portal under Operations => Databases.  Or you could just shut down Cache.  While the database is dismounted, replace the .DAT file with the one you downloaded, then re-mount the database (or restart Cache, if you had shut it down).

 

Yesterday I wrote up a high level overview of the installation steps, you may want to have a look at that as you work your way through the installation: OpenVista Server Installation Options

Jonathan Tai Medspherian 320 posts since
Jul 24, 2008
Currently Being Moderated
7. Jun 11, 2009 11:34 PM in response to: Govindaraj
Re: Mumps - intersystem cache server
Jonathan Tai Medspherian 320 posts since
Jul 24, 2008
Currently Being Moderated
9. Jun 12, 2009 7:39 AM in response to: Govindaraj
Re: Mumps - intersystem cache server

If you're running CIS on the same machine as Cache, then use 127.0.0.1 or localhost for the server name.  Otherwise, use the IP address of the machine running Cache.  Port 9201 is correct.

Jonathan Tai Medspherian 320 posts since
Jul 24, 2008
Currently Being Moderated
11. Jun 15, 2009 3:19 AM in response to: Govindaraj
Re: Mumps - intersystem cache server

Can you try telneting to the port from the Windows machine?  You can use the built-in telnet client in Windows (Start => Run, type "cmd", then in the Command Prompt type "telnet localhost 9201") or download and use PuTTY.  I'd like to see what response you get when you use telnet.

Jonathan Tai Medspherian 320 posts since
Jul 24, 2008
Currently Being Moderated
13. Jun 17, 2009 8:52 AM in response to: Govindaraj
Re: Mumps - intersystem cache server

The port is not actually listening, so I suspect that you never properly started TaskMan.  TaskMan spawns the listener, so if it is not running, the restart command has no effect.  Can you run

D ^ZTMON

 

in the mumps prompt and show us the output?  For future reference, you can also reach the Monitor TaskMan option from the menus (EVE => Taskman Management => Taskman Management Utilities => Monitor TaskMan)

More Like This

  • Retrieving data ...

Bookmarked By (0)