Hello all!
We would like to know what is the purpose of the SQL server? Is it really necessary? I mean, is the write operation on the Control-M/EM server not enough? Maybe it's a stupid question, but we really don't understand the utility of the process write and upload.
Is this just a space question or what?
Thank you.
SQL server
Hi Diablau,
I think there is a misunderstanding!
The write operation define all information about the job you have configured, into EM DataBase.
The upload operation make the same definition into Control-M Server DataBase.
Without SQL Server (For Windows and Oracle for Unix) this two operation are not possible because there is no DataBase on OS.
Moreover whithout SQL Server or Oracle you are not able to install Control-m EM or Server.
Best Regards
Giuseppe Nappo
I think there is a misunderstanding!
The write operation define all information about the job you have configured, into EM DataBase.
The upload operation make the same definition into Control-M Server DataBase.
Without SQL Server (For Windows and Oracle for Unix) this two operation are not possible because there is no DataBase on OS.
Moreover whithout SQL Server or Oracle you are not able to install Control-m EM or Server.
Best Regards
Giuseppe Nappo
Re: SQL server
I'd like to break this down. Your first question of the purpose of the SQL server. The database server in the control-m application is where all data is stored. Utilizing both internal and external coding the SQL data is the core of the scheduling system. Without a database, the data would need to be organized into thousands, if not millions, of files, and access times for that data would be greatly increased. So, in a word, the database is not only necessary, but imperative.Diablau wrote:Hello all!
We would like to know what is the purpose of the SQL server? Is it really necessary? I mean, is the write operation on the Control-M/EM server not enough? Maybe it's a stupid question, but we really don't understand the utility of the process write and upload.
Is this just a space question or what?
Thank you.
The write and upload functions are the moving of the data into first one then another database. You may not be aware, but there is a database server at both the EM and CTM/Server levels. The write places the initial definition information into the EM database. The upload takes the information from the EM database and replicates it into the CTM/Server database. Once the data has been propagated, the table/jobs are ready for running. The benefit of having two databases is numerous, but the most apparent to me is the staging capability.
I hope this helps answer your questions.
- th_alejandro
- Nouveau
- Posts: 188
- Joined: 26 Nov 2008 12:00
- Location: Bogotá
check this
Control-M is an application, it can be run on many databases, like SQL server. In fact Control-M is not a database engine, it's only an application that need to storage data in a database, may be oracle, sql server, postgres, etc.