The following post outlines an architectural design of intermediate complexity for DeepSee. As in the previous example, this implementation includes separate databases for storing the DeepSee cache, DeepSee implementation and settings. This post introduces two new databases: the first to store the globals needed for synchronization, the second to store fact tables and indices.
I'm creating a new namespace by the installation manifest XML and in the "database" tag configuration I don't see attribute to configure if I what jounal globals or not to this database.
I have a CACHE.DAT file that is working under CACHE version 2015.1.0.429.0
I have a second machine with CACHE version 2017.2.0.741.0
I have several stored procedures that when I execute them they will only return a single snapshot.
This tool is used to generate random read Input/Output (IO) from within the Caché database. The goal of this tool is to drive as many jobs as possible to achieve target IOPS and ensure acceptable disk response times are sustained. Results gathered from the IO tests will vary from configuration to configuration based on the IO sub-system. Before running these tests ensure corresponding operating system and storage level monitoring are configured to capture IO performance metrics for later analysis.
I have a SQL procedure that I call into and it does some processing and passes back any data validations that fail.
Hi,
I have a client who is considering encryption options in order to comply with a tendering requirement.
I have a lookup table and record batch Table I would like to do a count on the records stored in that batch by counting the number of records in that batch that have a certain key on the responseKey column.
I am planning to implement Business Intelligence based on the data in my instances. What is the best way to set up my databases and environment to use DeepSee?
Hi
The message is received at all times.
cconsole.log
Is there something in Cache that is equivalent to partitioning a table in Oracle? I'm trying to break some big tables into groups so that the most frequently accessed data is faster to retrieve.
I am trying to read data from MySQL Server 2012 to a stream and I keep getting an error here is my code so far
ERROR
Is there a way to pull a user name and password from the Credentials list that is kept in Ensemble? Right now I have a LDAP user that I have hard coded into my ZAUTHENTICATE, which I would like to get away from.
We have noticed in the course of the last 18 days our CACHE.dat has grown by 20 GB. Is there a way we can break down the data in CACHE.dat to see what could be growing in size?
Hello,
I have a property which I need to move from one class definition to another as follows:
Old definition:
Some of our interfaces use globals for lookups, but we are currently looking at putting a groups of (document) interfaces in a separate production with a shared ‘Default Database for Routines’ to reduce code duplication.
Hello everyone,
i want an automatic unidirectional syncronization of multiple databases (some tables from .dat file, not the whole .dat file) .
Hi, community
i am defining a new role on my system , i want that this role has access only to my own data base , do you konw which roles can i add to this one ?
thank you
Hi community,
my database (HSAUDIT) is only on the read mode , how can i pass to the Read/Write mode?
thank's
I am trying to replace one of our SQL Integration Service jobs with Ensemble and I am running into an issue executing a query against a MS SQL database using JDBC drivers.
I have two databases, and both of them have a global ^Data with subscripts going from 1 to 10 000 000.
I want to get one database with global ^Data but with subscripts going from 1 to 20 000 000.
Since each db is around 100 Gb and they are on a different hosts, what's the best way to merge them?
It was my answer to the question appeared in GoogleGroups. And when I answered there I figured out that it might worth to post an article and to add some light on how Unicode is stored in Caché.
Recently, we scheduled two tasks (1008 and 1009) within Task Manager. Task ID 1008 is set to run after Purge Tasks (%SYS-ID:3), and Task 1009 is set to run at 7:00:00 each day.
Currently, we are utilizing batch jobs at the OS level to kick off routines that watch for files. We are trying to convert these processes to be performed by the Task Manager.
While creating namespaces, there is a provision for keeping the data, and code separately in database.
What I am looking for,
What are the benefit we can achieve by doing this?
In which global cache class codes are storing in cache DB?
For example, Routine codes are storing in ^ROUTINE global.
