Question Mack Altman · Nov 1, 2018 What is best approach to parsing CSV string to tab-delimited string? In PHP, I'm able to utilize the implode and str_getcsv functions to convert a comma-delimited string to a tab-delimited string. The following is an example. #Caché #ObjectScript 0 33 1 2.7K
Question Mack Altman · Jun 25, 2018 Help with dynamic Xecute in curly brackets Typically, I have time to review the documentation, which I'm sure is here. However, I have a workaround (TEST1) but I was wondering if anyone could assist me in advising how I would need to adapt the curly brace snippet (TEST2) to provide the same result.Thanks for any help you can provide. #Caché #ObjectScript 0 3 0 310
Question Mack Altman · May 2, 2018 Is it possible to identify the work left for the current pass of write daemon? Currently, we are receiving an alert that states, "Write Daemon still on pass 31". It's been that way for a few hours. I was wondering if it is possible to identify what the WD has left to work on so that we can see how we can reduce this and possibly identify if there are issues with the way something is written. Thanks in advance for any insight. #Performance #Caché 0 4 0 685
Question Mack Altman · Apr 20, 2018 How to determine depth of a global? I was wondering if there was a way to easily identify the node depth of a global. Take the following global example. Is there way to determine the depth is 3? s ^global("first","second","third")="some^info^here" #ObjectScript #Caché 0 1 0 314
Question Mack Altman · Mar 19, 2018 What sends Write Daemon into Troubled status? Currently, we are running 2014.1 on two different servers (OpenVMS, RHEL). The plan is to transition from OpenVMS to RHEL, but our Write Daemon is in a Troubled state on both servers.On the OpenVMS server, we have a WIJ file that's 26G and can grow to 40G (size of database cache). Since it hasn't grown to 40G, we don't believe the size of the WIJ file to be the issue.What else should we be looking at regarding the performance of the Write Daemon? #Journaling #OpenVMS #Performance #Red Hat Enterprise Linux (RHEL) #System Administration #Caché 0 1 0 947
Question Mack Altman · Feb 16, 2018 Importing multiple records in CSV file I came across How to import a tab separated text file into a SQL table programmatically?, which appears to indicate that I can pass the filename and all records will be imported. However, when I put use the Import method only a single record gets imported. However, all records are imported if I use the management console to import the file by selecting it and choosing the options. Has anyone ran into this in the past? #CSV #DTL #Object Data Model #SQL #Caché 0 3 0 691
Question Mack Altman · Oct 11, 2017 Best method to transfer from OpenVMS to RHEL We will be transitioning from a server running HP OpenVMS to one running RHEL 7. The main question some of the team had was what would be the best method for moving the globals to the new system.Also, I was wondering if any others have transitioned from OpenVMS to RHEL. If so, were there any kinks that we should be aware of prior to transition? #OpenVMS #Red Hat Enterprise Linux (RHEL) #System Administration #Caché 0 2 0 871
Question Mack Altman · Sep 26, 2017 Task Manager failed executing RunLegacyTask 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. In attempt to provide as much detail as possible, each of the tasks are as follows: #Databases #Management Portal #ObjectScript #System Administration #Caché 0 4 0 825
Question Mack Altman · Sep 6, 2017 How can I use Task Manager to start a routine upon startup? 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. The routines have while loops and perform while loops so long as the time parameters are being met. What's the best way to ensure Task Manager kicks them off after the completion of the shutdown/backup/start process is performed, which we do nightly? I want to ensure that it starts it regardless of the time that we've set. #Management Portal #ObjectScript #System Administration #Caché 0 13 0 971
Question Mack Altman · Aug 11, 2017 What in the System Dashboard indicates performance issues? Please excuse my ignorance. I am trying to identify what areas would be best to review in the System Dashboard (for Cache 2010.2) for performance issues with the database. It seems to be running slower than usual, but I am trying to find out the best way to go about identifying what the issue is.The following are captures from the System Dashboard.As always, thanks a lot for your help. #Monitoring #Performance #Caché 2 3 0 575
Question Mack Altman · Aug 3, 2017 Retrieving attributes from Library.File() In reviewing the documentation found here, it states that there is an Attributes property. Since this is an array, I was wondering how I would go about traversing through the array to review what attributes are available on the file. #Object Data Model #ObjectScript #Caché 0 1 0 573
Question Mack Altman · Jul 12, 2017 Need clarification on usage of globals and global memory It is my understanding that when a routine accesses a global it is temporarily stored in global memory. While the global is within global memory, any other routine would be able to readily access the global from memory and not from disk so long as the same node is being utilized. #Globals #ObjectScript #Caché 2 2 0 404
Question Mack Altman · Jul 5, 2017 What does 'Unable to start the database read test' refer to? We are running Caché v2010.2 on OpenVMS and are receiving the message, 'Unable to start the database read test' in our CCONSOLE.LOG. I was wondering if anyone could offer some insight on this as I was not able to find the error mentioned in the documentation. #Databases #System Administration #Caché 0 2 0 278
Question Mack Altman · Mar 16, 2017 Recommendations for server configuration I have been asked to assist in the planning of the a new server for our database, which we will be changing operating systems from OpenVMS to Linux (RedHat distribution). However, its difficult to find material regarding what would be recommended, which is likely due to the database being proprietary.In looking at the information provided below and hoping to decrease processing time, would anyone be able to recommend type of configuration we should have for the new Linux server? Please feel free to ask any clarifying questions. #Performance #Red Hat Enterprise Linux (RHEL) #System Administration #Caché 0 2 0 1.5K
Question Mack Altman · Feb 23, 2017 How common is it to utilize $ZSTORAGE? While I can see the benefits that $ZSTORAGE could have if used properly, I have not seen it used in the environments I have worked in. I was wondering if there are any developers that promote its usage.If used properly, I would imagine it could be highly effective in maximizing free memory since some processes will never go over X amount, while others may very well need much more. #Caché #ObjectScript #Performance 0 2 0 392
Question Mack Altman · Jan 25, 2017 What is the easiest way to include an INCLUDE at the beginning of each MAC routine I am in the planning stages of making things more uniform in our routines and I would like to know what the easiest way would be to include an .inc at the beginning of each .mac routine. Has anyone written something that would open all routines and place something into the first row while leaving the rest of the routine unchanged? Thanks for any guidance you all may provide. #ObjectScript #Caché 0 3 0 368
Question Mack Altman · Jan 21, 2017 What is the base formula used for calculating global storage? Can someone direct me to where in the documentation we can find how consumption may be calculated for global storage?Caché Version2010.1Operating SystemHP OpenVMS 8.4EDIT: After receiving some responses, it seems I was unclear in my initial inquiry. I am looking to determine our rate of consumption of storage; however, I am having some difficulty in doing that. #Caché #Databases #Globals #OpenVMS #System Administration #Monitoring #Performance 0 6 0 807
Question Mack Altman · Jan 6, 2017 What is the best method for copying Mappings and Routines? Currently, we have an application running in one namespace ("Database B") that has globals and routines mapped to another database ("Database A"). After enforcing clean up on Database A, we found that 90% of the disk is free. We would like to compact Database A and release the unused space. However, we are running OpenVMS, which seems to be the issue. For databases consisting of only globals, we are able to use ^GBLOCKCOPY; however, we need to ensure that the routines and mappings are also copied. #Databases #Globals #Mapping #Namespace #OpenVMS #System Administration #Caché 1 8 0 1.1K
Question Mack Altman · Dec 27, 2016 Using global mapping for redirecting new entries into global Currently, namespace Alpha is configured to use database AlphaDB as its global database. How would we go about having namespace Alpha configured to use database AlphaDB for its global database except where global ^Customers(CustomerId) has a CustomerId greater than 10M, which we would like to have it redirected to database BetaDB. In other words, ^|"AlphaDB"|Customers contains all customers between 1 and 10,000,000; and ^|"BetaDB"|Customers contains all customers greater than 10,000,000. Any help would be appreciated. #Databases #Globals #Mapping #Namespace #Caché 0 4 0 502
Question Mack Altman · Dec 2, 2016 What are best ways to query large tables? We don't often use SQL within our org, which is mostly due to the performance issue we experience due to the quantity of data we are reviewing.Aside from the standard performance measures for non-Caché databases, are there any recommended approaches when querying large tables?The table would have roughly 50M records, but there are not a finite amount of sub-nodes. #Databases #ObjectScript #SQL #Performance #Caché 0 7 0 983