Globals | InterSystems Developer Community

Question

Robert Cemper · Mar 13, 2023

Those of you that worked already with ECP might know that it operates not only across
operating systems, processor technologies (big-little-endian), but also -with limits- across versions in C/E.
This cross-version feature also includes IRIS (verified for 2020.1) and C/E (2018.3)

#ECP #Globals #Caché #Ensemble #InterSystems IRIS

7 2

1 634

Question

Evgeny Shvarov · May 29, 2017

Globals vs Locals: What Is Faster?

Hi, colleagues!

Consider you need to put some (less than 1GB) data to an indexed array and do some data manipulations and calculations with it.

Should I prefer global or local for it?

Is there any general rule when local is faster than global and vice-versa?

#Globals #Performance #Caché

4 5

0 1.4K

Question

Alexander Brown · Feb 6, 2017

Lookup Time Complexity of a Global

If I were trying to access an index of a global variable, what time complexity would this operation have? My understanding of languages like Java/C++ is that arrays are stored as blocks of memory so that x[15] would have a lookup time complexity of O(1) because it just goes to (address of the array + 15) and retrieves the value stored there.

How does this work in Cache where the index of a variable isn't necessarily an integer value? If I were to have a variable like the following:

x("Adam") = "Red"

x("George") = "Blue"

x("Bryan") = "Green"

etc...

#Globals #Object Data Model #ObjectScript #Performance #Caché

3 5

0 484

Question

Sukhpreet Singh · Jul 15, 2023

Can we fetch data from a global if name of the global is stored in a string?

I have created a global say ^myglobal and entered some data. I am storing the name of global in databases and fetching the name based on some criteria. I am getting "^myglobal" in return from databases but i am not able to fetch the data I stored in the global.

I tried set var = result.global which gives me "^myglobal" in var. Doing WRITE var will return "^myglobal" and not the data i stored in this global.

#Globals #Namespace #InterSystems IRIS

3 5

1 248

Question

Eduard Lebedyuk · Oct 26, 2017

Get class property position in storage $lb

I have a classname and a property name. I want to know, when I get object value directly from a global, which property corresponds to which position in the $lb structure.

Here's what I got so far:

#Caché #Globals

3 6

0 579

Question

Rathinakumar S · Jul 26, 2023

Any other options to Iterating entries in a global faster

Hi,

We have a global with 65 million entries. All we are doing is just iterating through each entry to find out the total no of entries. It is currently taking 110 minutes. Is this something normal? What can we do to speed up this process? Below is the program for just iterating each entry in the global.

s sub=" ,count=0
f{
s sub=$o(^YYY(sub)) q:sub=""
s count= count +1
}
w!, "Total Count:"_ count

#Globals #Key Question #Caché #InterSystems IRIS for Health

3 19

1 421

Question

Rajeev Karki · Apr 17, 2016

Partitioned tables

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.

Here is some information on this concept from Oracle.

https://docs.oracle.com/cd/B28359_01/server.111/b32024/partition.htm

#Caché #Databases #Globals

3 4

0 958

Question

Sukhpreet Singh · Jul 15, 2023

Is there any way to create a global that will be available in all the namespaces?

I want to fetch value from a global without being limited by the namespace. Is there any way of referencing the values from a global to a different namespace?

#Globals #Namespace #InterSystems IRIS

2 3

1 224

Question

Evgeny Shvarov · Oct 6, 2022

What is the Analog of $DATA for Embedded Python?

Hi folks!

I'm working with a global via Embedded Python as a class method. I init the handler for a global via:

gl=iris.gref("^Global")

What is the way to check the value at index ^Global("x","y")? E.g.:

In ObjectScript I'd do the following:

#Embedded Python #Globals #ObjectScript #InterSystems IRIS

2 4

0 216

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 364

Question

Robert Hanna · Aug 23, 2019

Traverse Global Subscripts while using Indirection

Hi all,

I am trying to create a method to count the number of entries in a global, including all subscripts. I am having a bit of trouble getting the code to make it to the second subscript. When I get to the position where my key is "Canada" and I add a comma and empty quotes to it, it returns USA as the new key when I do the order function. Is the $Order or the global not able to use a single string to represent multiple subscripts?

Here is my global structure:

#Globals #Caché #Ensemble #HealthShare

2 20

0 609

Question

Robert Cemper · Mar 13, 2023

Stream migration from old Caché format to IRIS

During a migration from a rather old Caché Version (2016.1) to IRIS
I met the problem to migrate Streams.
The difference in the storage Global is minimal
It's not a big effort to do it manually for a few streams.
But for some thousand streams I hope there is a tool already available.
But where?

#Globals #Caché #InterSystems IRIS

2 2

0 300

Question

Arto Alatalo · Mar 27, 2020

Management Portal: how to view globals in opposite order?

A simple question: View Global Data page shows globals always in ascending subscript order. Very often I need to see latest page, is there any trick for this?

Update: I mean to see last subscripts in Management Portal, not using the code

#Globals #Management Portal #Caché

2 27

0 658

Question

Robert Cemper · Mar 17, 2023

A confusing experience

During my last migration to IRIS I met this Compatibility parameter

NullSubscripts true

0 - Throw error when referencing a null subscript.
1 - Null subscript references do not throw an error.

The consequences are shocking. This was allowed:

#Globals #Other

2 5

0 289

Question

Norman W. Freeman · Oct 1, 2020

Is there a built-in method to escape special characters in a string, in a similar way to what is done by Portal with global data ?

If a global node contains special characters, (eg : a line returns), it will be displayed like this in Portal ("System > Globals > View Global Data" panel) :

^A(1) = "this is"_$c(13,10)_"a test"

I would like to export global data to a txt file using a similar format.

I already wrote the main code (that loops on all nodes and dump them to file), the problem is how to handle special characters.
For the moment I replace them manually one by one. It works, but it's far from perfect :

#Globals #Caché

1 5

0 1.4K

Question

David Reche · Apr 3, 2016

Best Ensemble Global Buffer Configuration

Usually I recommend to set the global buffer (GB) as large as possible in order to maintain in memory more globals as possible. I don't know if this is a standard recommendation, but I want to discuss what should be the best buffer size for a Ensemble instance that only process messages.

#Globals #Ensemble #System Administration

1 6

0 2K

Question

AndreClaude Gendron · Apr 19, 2016

Unable to store (or rather retrieve) OREF in globals - Trying to create a Singleton Class.

We are trying to create a simple class extending %RegisteredObject that could be used as a singleton. However we are not able to store it in a global to later be retrieved (by the same process but elsewhere in the code).

I resumed my issue in this small code sample :

#Globals #Object Data Model #ObjectScript #Caché

1 8

0 747

Question

Scott Roth · Feb 23, 2018

Pulling information from Credentials using Cache Object Script

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. I am not to familiar with settings Global, or calling them at least.

Thanks

Scott

#Databases #Globals #LDAP #Object Data Model #Security #Ensemble

1 12

0 2K

Question

Sylvain Guilbaud · Sep 8, 2023

How to do a SQL query on a multilevel global and display each level in the same table ?

Hello,

I have a global whose structure is multi-level and I am trying through a class and a SQL query to display a table which includes all the values and levels.

#Globals #Mapping #SQL #Caché #InterSystems IRIS

1 2

0 260

Question

Norman W. Freeman · Aug 27, 2021

How to iterate a local array with $QUERY() in a job ?

In Caché, it's possible to iterate a local array using $QUERY() :

set a("foo") = 50
set a("bar") = 30

set key = "a"
for
{
     set key = $QUERY(@key)
     quit:key="" 
     write key_" = "_@key
}

This code works perfectly, unless it's called in a job (eg: a routine called by the JOB command).

#Globals #Caché

1 3

1 335

Question

João Carlos Azevedo · Oct 23, 2023

List of global referenced process, similar to $zreference

I need to develop a tool to help to get what data is being consumed by a certain process, in order to get all data used to build an automated test scenario.

For example, some user process will pull data from ^GLOBAL(1)="dataString", ^GLOBAL(2)="dataString2", ^GLOBAL1(1)="data1String", ^GLOBAL2(4)="data2String4". Amidst all other data on these Globals, I will ignore everything that was not used in the user process, and get the specific keys used on it.

#Globals #Monitoring #System Administration #Caché

1 12

0 378

Question

Timothy Leavitt · Jul 11, 2017

Utility to find differences between databases?

Does anyone know of a utility to compare two databases (i.e., CACHE.DAT files) and find globals/subscripts that are different between them?

If not, I'll write one and share it.

#Caché #Databases #Globals #Deployment

1 6

0 766

Question

Guilherme Koerber · Sep 9, 2021

Default Purge Does Not Delete Streams

Hello community!

I'm facing a base growth issue, which is being generated by a process and an Ensemble feature.

When executing the process of cleaning up the message queues, the Ensemble “preserves” the Streams that were part of these messages, deleting only the Header and Body. In this way the database (of one of the namespaces) has grown around 60GB per day, which has been maxing out the disk capacity.

InterSystems informed that this is a characteristic and that it is explained in the documents mentioned below.

#Globals #Ensemble

1 2

0 656

Question

Richard Rayburn · Mar 22

How to map legacy global to a class using VisualStudio Editor?

In cache studio there are features, dialog boxes, that help map data from a global to class properties.
I have used %CacheSQLStorage quit a bit, or have in the past, to map globals to classes.

I haven't been able to find a similar feature in VisualStudio.
Do I need to upgrade to IRIS to be able to use VisualStudio to map global properties to classes?

Thanks for your time,
Richard

#Globals #Mapping #ObjectScript #Caché #InterSystems IRIS #VSCode

1 2

0 72

Question

Eduard Lebedyuk · Sep 16, 2016

Exporting global nodes to xml

Let's say I have a global named ^a and I need to export its nodes 1, 2, 3, 5 only.

Currently I write something like this:

Write $SYSTEM.OBJ.Export("a(1).gbl,a(2).gbl,a(3).gbl,a(5).gbl", "C:\Users\eduard\Desktop\a.xml")

Is there a way to write it shorter? I want to write global node once and list all the subscripts I need.

#Caché #Globals

1 1

0 644

Question

Peter Stordiau · Feb 20, 2022

Maximum Global Size ?

Dear people,

I (really) spent hours on finding the maximum size a Global is allowed to be (for Windows, if that matters). All I seem to run into are database sizes (derived from a max number of blocks and block size), but I refuse to believe that is correct because too small to be realistic.

#Databases #Globals #Caché #InterSystems IRIS

1 11

0 525

Question

Kurro Lopez · Aug 23, 2017

$Order and $Next in Cache Basic script

Hi all,

I need to create a routine to modifiy some values in a global.

My first attempt was:

#Globals #Object Data Model #Caché

1 3

0 473

Question

Punit Shah · Apr 24, 2023

Using %Stream.FileBinary's ClassMethods to set where a Stream is saved

I have a %GlobalBinaryStream object that I'm trying to save as a local file after being received through a SOAP Web Service.

To do this, I created a %Stream.FileBinary object and wanted to set where the stream copied to this object would be saved by using either the DefaultStreamDir() ClassMethod or the NewFileName() ClassMethod. However, the documentation isn't very helpful on how to use these ClassMethods.

Right now, I have the below code:

#Code Snippet #Globals #ObjectScript #SOAP #InterSystems IRIS

1 4

0 203

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.

#Caché #Databases #Globals #Namespace #Mapping #OpenVMS #System Administration #Performance

1 8

0 1K

Question

Kurro Lopez · Sep 13, 2018

Purge Task History manually

Hi,

I've read into console.log that there is some problems writing the global Task History

09/13/18-09:33:00:109 (9052) 0 Error al escribir en global de historial de tareas - Error (ERROR #5002: Error de cache: <DATABASE>%SaveData+20^%SYS.Task.History.1 ^SYS("Task","HistoryD",66179),c:\intersystems\healthshare\mgr\)

#Globals #Ensemble

1 2

0 383