All Discussions

Thanks Markus, this one is neat �� Beautiful one liner ! And thank you for the other solutions too ( Lester, Art, Doug ) I have been rude not to thank you, but a bit overload here. Thanks all!

Thank you for your answer, Great that IBM clarified it for us. Another thing, IBMers should get a tag or similar, so that you guys are easily distinguished from non-IBMers, when reading the discussions. ...

Hi Arturo, Maximo V7.6.1 has upgraded its Java version to 8. It has changed the default JavaScript engine named Nashorn that Oracle's in-house JavaScript implementation of script engines, instead of previously ...

Take a look at the resources we mentioned during the webinar below: Visit our new Remote Data Science website ibm.co/RemoteDataScience ------------------------------ Kunal Sawarkar -------------- ...

OOps - bugfix: $ dbschema -d $DATABASE -hd all | nawk 'BEGIN(S="UPDATE STATISTICS %s FOR TABLE %s(%s) DISTRIBUTIONS ONLY;\n";printf("SET PDQPRIORITY 25;\nUPDATE STATISTICS LOW DROP DISTRIBUTIONS;\n"))(if($1~/^Distribution/)(split($3,T,".");OT=T[1]"."T[2];C=C","T[3]);if($0~/ ...

You are asking questions that depend insight on how the actual system is setup and what the exact requirements are - I cannot help with that without understanding the implementation/requirement in more ...

the message indicate an env variable has not been set have you checked that - if not set : have you set it ? what was the result remember : for each question there is an answer.. read the message .. try ...

Hi Arturo, First of all - Interesting name for me as I just watched Money Heist! :) Coming back to your question: I think it is happening because Maximo changed the javascript engine in 7.6.1. Here below ...

and if someone prefer multi column update stats: dbschema -d DATABASE -hd all | nawk 'BEGIN(S="UPDATE STATISTICS %s FOR TABLE %s(%s) DISTRIBUTIONS ONLY;\n";printf("SET PDQPRIORITY 25;\nUPDATE STATISTICS ...

https://www.ibm.com/demos/collection/IBM-Cloud-Pak-for-Applications/ ------------------------------ Michael Buss Sign up for IBM Cloud Pak Demo Days + Office Hours Series : https://ibm.co/3cIL3MV ---- ...

Hello Eric, here is the one-liner to get statistics from dbschema -hd: $ dbschema -d DATABASE -hd all | nawk 'BEGIN(printf("SET PDQPRIORITY 25;\nUPDATE STATISTICS LOW DROP DISTRIBUTIONS;\n"))(if($1~/^Distribution/)(split($3,T,"."));if($0~/ ...

Mainframe Trivia - let's try again Well this has never happened before - no one entered last week's t-shirt challenge! I asked for Mainframe Trivia and the only post was encouraging all of the mainframe ...

This session will explore how Cognos Analytics is using Jupyter notebooks to bring the insights from the data scientists in an organization to the business analysts. This will include the integrated notebook ...

Your smart phone buzzes with an alert: the latest round of orders is exceeding your production capacity this month! You tap the alert and get a chart that shows you which regional office that has caused ...

Thank you Sylvain for this exhaustive write up on SNMP. This is very informative and helpful to my current work. I am not sure why, many have not explored a lot on this feature of ISAM. I am planning ...

Please check whether XML Management interface is enabled on DP. ------------------------------ Hermann Stamm-Wilbrandt Compiler Level 3 support & Fixpack team lead IBM DataPower Gateways (⬚ᵈᵃᵗᵃ / ⣏⠆⡮⡆⢹⠁⡮⡆⡯⠂⢎⠆⡧⡇⣟⡃⡿⡃) ...

Hi all, I was doing the Coursera course when I start learning about the DB2. Today I downloaded DB2 on my local machine. Where can I find out how to work with this? I know how to work with it on the cloud ...

Hi there, I need to calculate the total of numerical values from a variable. The values actually represent the number of persons. But since the data is based on documents from the past there is few missing ...

Preparing for a pandemic is a daunting task for hospitals and care facilities all around the world. In this session North York General Hospital, a leadinghealthcare facility in Toronto, Canada, will ...

You can check Relative date functionality in Data Module to see if it works for your requirement. ------------------------------ Buddhi Gupta ------------------------------

Hi all, In 11.1.6, I wonder is there an option in creating a URL to a dashboard that will collapse the filter panel upon opening the dashboard? Or possibly hide it? I don't see it listed in the documentation ...

Arjen: This is definitely some kind of trusted host issue. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: ...

Hi again, I have crawled through the registry and compared it with production, looks pretty much similar. Accounts, SQLHOSTS, Groups, it is all in there. Could somewhere in the restored database itself ...

As I recall, IBM Sense events were related to UBA. On what version of QRadar are you? Is it an All-in-One install? Did you notice anything interesting in the qradar.error log file? Do you have QDI installed ...

QueBIT's Print Reports feature is designed to replicate the core functionality from TM1 Perspective's own utility of the same name for Planning Analytics for Excel (PAfE) users. But, it also comes with ...