Question Eduard Lebedyuk · Oct 12, 2023 Snowflake - Key Pair Auth Has anyone tried to authenticate IRIS client in Snowflake using Key Pair Auth as described in this doc? #Interoperability #InterSystems IRIS 0 0 0 178
Question Eduard Lebedyuk · Oct 3, 2023 Healthcheck in a container without PWS What's the way to get healthcheck info for an IRIS (container) running without PWS? #Containerization #Monitoring #InterSystems IRIS 0 2 0 167
Question Eduard Lebedyuk · Jul 20, 2023 Caching inProc BOs between invocations? I have the following setup: REST broker calls inProc BO via BS. As BO initialization is time-consuming, I want to reuse the same BO during the CSP process lifetime. I have tried the following approaches: #Business Operation #Business Service #CSP #Interoperability #REST API #InterSystems IRIS 2 0 0 102
Question Eduard Lebedyuk · Jul 13, 2023 How can I run an iris sql command using AWS SSM? I'm trying to execute SQL on a EC2 via SSM: import boto3 instanceid = "i-123456789" sql = """SELECT path FROM Security.Applications WHERE ID = '/csp/sys'""" template = """su - irisusr -c 'cat << EOF | iris sql iris -U %SYS """ + sql + """ q EOF' """ template = [line.strip() for line in template.splitlines()] template = """\n""".join(template) ssm_client = boto3.client('ssm') response = ssm_client.send_command( InstanceIds=[instanceid], DocumentName="AWS-RunShellScript", Comment=AWS, Parameters={'commands': template}) #AWS #Cloud #SQL #InterSystems IRIS 0 0 0 173
Question Eduard Lebedyuk · Jan 19, 2023 Autoscaling Business Service to consume available CPU I have a production with one Business Host - a Business Service which I need to scale automatically to consume ~80% of CPU time.Business Service pulls data from a (non-FIFO) queue so that I can adjust pool size without any issues. So far, I'm planning a different BS running every X seconds and sampling CPU with $system.Process.GetCPUTime() and scaling the pool size of the main BS up/down based on that metric. Has anyone tried something similar? Any advice/code samples would be appreciated. #Business Service #Interoperability #InterSystems IRIS 1 6 0 260
Question Eduard Lebedyuk · Jun 26, 2017 iFind and HTML text I have a class with text property, which contains html text (usually pieces, so it may be invalid), here's a sample value: <div moreinfo="none">Word1 Word2</div><br> <a href = "123" >Word3</a> When I add iFind index on text, there are at least two problems: #iFind #InterSystems Natural Language Processing (NLP, iKnow) 1 4 0 462