List of Contributions

Shadman Aziz

Contact Details

My Content

1 to 20 of 50+ total
Posted By Shadman Aziz Thu April 08, 2021 09:58 AM
Found In Egroup: Db2
\ view thread
Hello, The question is being forwarded to Db2 Documentation team and awaiting their input. Regards,
Posted By Shadman Aziz Thu April 08, 2021 09:58 AM
Found In Egroup: Db2
\ view thread
Hello, The file README.TXT states that one should use the following commands to start/stop the Knowledge Center on non-Windows platforms: > ./bin/startKC.sh > ./bin/stopKC.sh Unfortunately, the files startKC.sh and stopKC;sh are not present in the subdirectory bin. Is the beta documentation ...
Posted By Shadman Aziz Thu April 08, 2021 09:58 AM
Found In Egroup: Db2
\ view thread
Hi @roland_Schock We have a defect for this and we are trying to have it in all special build and next drop of Db2.
Posted By Shadman Aziz Thu April 08, 2021 09:56 AM
Found In Egroup: Db2
\ view thread
Hello @Roland_Schock Db2 11.1.4.4 GA'd on Nov 27th 2018. We are working on the next EAP and should be available soon.
Posted By Shadman Aziz Thu April 08, 2021 09:53 AM
Found In Egroup: Db2
\ view thread
Hi, I am puzzled by the time I spend and loose trying to install DB2 PureScale on a RHEL 7.x VMWARE. The install (on psnode2 only for now) of 11.1.3.3 CODE ONLY simply fails. (db2prereqchecks is successfull) [root@psnode2 tmp]# cat /etc/redhat-release Red Hat Enterprise Linux Server release ...
Posted By Shadman Aziz Thu April 08, 2021 09:52 AM
Found In Egroup: Db2
\ view thread
As per the DB2 Day in London on Monday JSON support MAY be coming in Fixpack 4. At the DB2 Day in London George Baklarz mentioned that Morgan Stanley are giving a talk on the new JSON feature as IDUG NA 2018, as Early Access Preview people when are we getting access to this? Regards, ...
Posted By Shadman Aziz Thu April 08, 2021 09:48 AM
Found In Egroup: Db2
\ view thread
Example of FETCH : Identification Division. Program-ID. "openftch". Data Division. Working-Storage Section. copy "sqlca.cbl". EXEC SQL BEGIN DECLARE SECTION END-EXEC. 01 dept-rec. 03 pname pic x(10) OCCURS 5 TIMES. 03 dept pic s9(9) comp-5 OCCURS 5 TIMES. 03 cnt pic s9(9) ...
Posted By Shadman Aziz Thu April 08, 2021 09:48 AM
Found In Egroup: Db2
\ view thread
I have received the message about the V1.1.4.4 EAP. When I click there, I go to a bluemix page. Once there, I get the code and a link to IBM. However, in that last page, I got what it is in the attached image, and I cannot go further. What can it be? 1 image associated with this topic ...
Posted By Shadman Aziz Thu April 08, 2021 09:48 AM
Found In Egroup: Db2
\ view thread
Hi David, Morgan Stanley actually was discussing their use of the "proprietary" JSON functions we started revealing around the time that Db2 11.1 GA'd and then documented (SQL access to JSON documents https://www.ibm.com/support/knowledgecenter/SSEPGG_11.1.0/com.ibm.swg.im.dbclient.json.doc/ ...
Posted By Shadman Aziz Thu April 08, 2021 09:47 AM
Found In Egroup: Db2
\ view thread
Hi. I agree, I was also surprised that the reg var did not mention that it is dynamic. I think it would be helpful to mention whether a reg var is dynamic or not. There currently doesn't seem to be a standard for this but I will follow up with development and see if this can be done, at the very least ...
Posted By Shadman Aziz Thu April 08, 2021 09:47 AM
Found In Egroup: Db2
\ view thread
It would help if you could provide sample of array support - hopefully using COBOL. program I tried is based on DB2 z/OS sample #Db2
Posted By Shadman Aziz Thu April 08, 2021 09:47 AM
Found In Egroup: Db2
\ view thread
Hi, Looks like there is a bug while precompiling if the target is MF cobol. fWhile precompile use the option TARGET IBMCOB to generate the correct code and test it. Detailed discussion about this problem is found on this thread. https://www.ibm.com/developerworks/community/forums/html/topic?id ...
Posted By Shadman Aziz Thu April 08, 2021 09:47 AM
Found In Egroup: Db2
\ view thread
The samples I tested are similar to examples you provided and my tests either insert or fetched only one row after I fixed one of the variables in the generated new API call. I tested using Windows 10 so that may be part of the reason.
Posted By Shadman Aziz Thu April 08, 2021 09:47 AM
Found In Egroup: Db2
\ view thread
Hi, It seems the DB2_BCKP_PAGE_VERIFICATION registry cannot be applied with -immediate flag. I would like sometimes to be able during a backup, to do a sanity check of my databases at the same time, but I cannot stop the applications in Production. What does prevent the -immediate flag to be used ...
Posted By Shadman Aziz Thu April 08, 2021 09:47 AM
Found In Egroup: Db2
\ view thread
Hi. What Db2 version are you on? It is a dynamic registry variable in that no db2stop/db2start is needed. What makes you say that -immediate flag doesn't work? > db2start SQL1063N DB2START processing was successful. > db2set DB2_BCKP_PAGE_VERIFICATION=on -immediate > db2set DB2_BC ...
Posted By Shadman Aziz Thu April 08, 2021 09:46 AM
Found In Egroup: Db2
\ view thread
Hi, I find much regrettable that SYSCAT.INVALIDOBJECTS has 'F' for objectype, meaning "routine", when ADMIN_REVALIDATE_DB_OBJECTS has object_type 'Function' or 'Procedure'. Can't you be simple and support both 'F' and 'P' so that we would logically call in scripts ADMIN_REVALIDATE_DB_OBJECTS with ...
Posted By Shadman Aziz Thu April 08, 2021 09:46 AM
Found In Egroup: Db2
\ view thread
Hi Jean-Marc, I looked into this and I believe it is the unfortunate result of multiple object types being mapped onto the same representative value in SYSCAT.INVALIDOBJECTS. All routines (e.g. methods, procedures, functions) that have their own independent identity (and catalogs) in the product ...
Posted By Shadman Aziz Thu April 08, 2021 09:44 AM
Found In Egroup: Db2
\ view thread
Hi Jean-Marc, we're planning to continue to refresh the EAP (beta) roughly every four weeks, although with a possible brief intermission for the holiday season. To my knowledge the release date of 11.1.3 has not yet been carved in stone. 11.1.2 iFIx002 was just deployed in the last few days as ...
Posted By Shadman Aziz Thu April 08, 2021 09:44 AM
Found In Egroup: Db2
\ view thread
Hi Kelly, Thanks for your quick reply that helps :-). Best regards, JMB
Posted By Shadman Aziz Thu April 08, 2021 09:44 AM
Found In Egroup: Db2
\ view thread
Hello, Do you plan to have a new FP3 beta drop ? Do you have a target date for FP3 release ? Thanks & Kind regards, JMB #Db2 #Db2EarlyAccessProgram(EAP)Forum