FTP from z/OS PDS to server (how to add on .txt extension)
I’m relatively new to FTP. Have written a JCL which will copy all members of a local PDS to a remote server. This process is somewhat successful, however all the same named filenames on the remote server reflect only the PDS member name (without any extension). Have used the LCD command to map to the [...]
Answer Question
| June 22, 2011 10:04 PM
FTP, MPUT, Partitioned Data Sets (PDS), PDS, z/OS
I’m relatively new to FTP. Have written a JCL which will copy all members of a local PDS to a remote server. This process is somewhat successful, however all the same named filenames on the remote server reflect only the PDS member name (without any extension). Have used the LCD command to map to the [...]
Answer Question
| June 22, 2011 10:04 PM
FTP, MPUT, Partitioned Data Sets (PDS), PDS, z/OS
COBOL TGT At Run Time
Is it possible to get access to the Cobol Task Global Table at run time in batch and cics (Enterprise Cobol for zOS)? I understand that using register 13 you can get access to the DSA, and using the DSA you can get access to the TGT, but I don’t know how to get access [...]
Answer Question
| April 23, 2008 3:23 AM
COBOL, z/OS
Is it possible to get access to the Cobol Task Global Table at run time in batch and cics (Enterprise Cobol for zOS)? I understand that using register 13 you can get access to the DSA, and using the DSA you can get access to the TGT, but I don’t know how to get access [...]
Answer Question
| April 23, 2008 3:23 AM
COBOL, z/OS
DB2 image copy that is no longer in SYSCOPY on zOS operating system
We have a tablespace that needs to be restored from an image copy which we have the problem is the image copy is not recorded in SYSCOPY. We also tried doing a UNLOAD FROMCOPY thinking if we got the data out of the image copy we would be able to load it back into the [...]
Answer Question
| May 3, 2010 5:27 PM
DB2, SYSCOPY, z/OS
We have a tablespace that needs to be restored from an image copy which we have the problem is the image copy is not recorded in SYSCOPY. We also tried doing a UNLOAD FROMCOPY thinking if we got the data out of the image copy we would be able to load it back into the [...]
Answer Question
| May 3, 2010 5:27 PM
DB2, SYSCOPY, z/OS
Common SMP/E base – Two different environments – User exits
Hello, Just wondering how the following situation can be addressed while remaining faithful to SMP/E: we have two different environments that we’re both migrating to z/OS 1.9. In so doing, we want to have a single SMP/E environment for z/OS, as the differences between the two reside elsewhere. There are a couple of niggles, however; [...]
Answer Question
| March 10, 2008 3:02 PM
SMP/E, z/OS
Hello, Just wondering how the following situation can be addressed while remaining faithful to SMP/E: we have two different environments that we’re both migrating to z/OS 1.9. In so doing, we want to have a single SMP/E environment for z/OS, as the differences between the two reside elsewhere. There are a couple of niggles, however; [...]
Answer Question
| March 10, 2008 3:02 PM
SMP/E, z/OS
left outer join in trigger DB2 Z/OS
I’m having problems writing a trigger that contains a left outer join. Here is the trigger: CREATE TRIGGER H000.H0TRCAD2 AFTER DELETE ON H000.H0COO_TRANS_CALLC REFERENCING OLD AS OLD_ROW FOR EACH ROW MODE DB2SQL BEGIN ATOMIC SELECT OLD_ROW.CLNT_ID , OLD_ROW.ACCT_NBR , OLD_ROW.PST_DT , OLD_ROW.ITM_SEQ_NBR , OLD_ROW.CREAT_TS , OLD_ROW.ALLC_SEQ_NBR , OLD_ROW.ACCTG_CDE , OLD_ROW.ALLC_AMT , OLD_ROW.CREAT_USR_ID , OLD_ROW.UPDT_USR_ID , [...]
Answer Question
| July 21, 2008 3:34 PM
DB2, LEFT OUTER JOIN statement, Triggers, z/OS
I’m having problems writing a trigger that contains a left outer join. Here is the trigger: CREATE TRIGGER H000.H0TRCAD2 AFTER DELETE ON H000.H0COO_TRANS_CALLC REFERENCING OLD AS OLD_ROW FOR EACH ROW MODE DB2SQL BEGIN ATOMIC SELECT OLD_ROW.CLNT_ID , OLD_ROW.ACCT_NBR , OLD_ROW.PST_DT , OLD_ROW.ITM_SEQ_NBR , OLD_ROW.CREAT_TS , OLD_ROW.ALLC_SEQ_NBR , OLD_ROW.ACCTG_CDE , OLD_ROW.ALLC_AMT , OLD_ROW.CREAT_USR_ID , OLD_ROW.UPDT_USR_ID , [...]
Answer Question
| July 21, 2008 3:34 PM
DB2, LEFT OUTER JOIN statement, Triggers, z/OS
Getting RACF Active Classes List
Hello, I am developing an assembler code (z/OS) getting the RACF Active Classes List. It should use CDT (CNST) and RCVTVCPR (RCVT), I suppose, but I haven’t understood how this RACF algorithm works. Can anybody help, please? Thanks
Answer Question
| January 23, 2008 4:54 PM
CDT, RACF, RRCVTVCPR, z/OS
Hello, I am developing an assembler code (z/OS) getting the RACF Active Classes List. It should use CDT (CNST) and RCVTVCPR (RCVT), I suppose, but I haven’t understood how this RACF algorithm works. Can anybody help, please? Thanks
Answer Question
| January 23, 2008 4:54 PM
CDT, RACF, RRCVTVCPR, z/OS
Reporting for RACF (Resource Access Control Facility) question
A question that was emailed to us: We are running RACF on a Z/OS mainframe and I am trying to get a report from RACF detailing users that have group access. I have a list from DSMON that tells me who has the special attribute on group connect but wanted a listing of each group [...]
Answer Question
| January 10, 2008 5:04 PM
DSMON, RACF, Resource Access Control Facility, z/OS
A question that was emailed to us: We are running RACF on a Z/OS mainframe and I am trying to get a report from RACF detailing users that have group access. I have a list from DSMON that tells me who has the special attribute on group connect but wanted a listing of each group [...]
Answer Question
| January 10, 2008 5:04 PM
DSMON, RACF, Resource Access Control Facility, z/OS
The News Show
Just wondering what you all thought of this — kind of teeny tiny TechTV? http://www.thenewsshow.tv/
Answer Question
| August 17, 2005 7:07 PM
z/OS
Just wondering what you all thought of this — kind of teeny tiny TechTV? http://www.thenewsshow.tv/
Answer Question
| August 17, 2005 7:07 PM
z/OS
Setup Remote printer in zOS
We have zOS v1R4 in a z900 mainframe server. I am a newly joined MVS system programmer here in this Datacenter. My requirement is as follows: 1) Currently we use TCP/IP to connect to LPARs in the mainframe 2) There is a remote laser printer in the client place(which is already networked) 3) We would [...]
Answer Question
| June 18, 2005 3:46 PM
Capacity planning, Hardware, Integration with other platforms, Logical partitions, Mainframe, MVS, z/OS, z/OS configuration
We have zOS v1R4 in a z900 mainframe server. I am a newly joined MVS system programmer here in this Datacenter. My requirement is as follows: 1) Currently we use TCP/IP to connect to LPARs in the mainframe 2) There is a remote laser printer in the client place(which is already networked) 3) We would [...]
Answer Question
| June 18, 2005 3:46 PM
Capacity planning, Hardware, Integration with other platforms, Logical partitions, Mainframe, MVS, z/OS, z/OS configuration
BMP scheduling of IMS and DB2 database access.
Application developers have nearly completed a conversion from IMS to DB2. They have used BMP to leave their test subsystems available to online tranactions. One day BMP users of BMP failed with U3042. This only occured for BMP users testing with IMS & DB2 databases. I am investigating the issue, without much IMS support experience. [...]
Answer Question
| May 27, 2005 1:02 PM
DB2, Instant Messaging, OS/390, UDB for mainframe, z/OS
Application developers have nearly completed a conversion from IMS to DB2. They have used BMP to leave their test subsystems available to online tranactions. One day BMP users of BMP failed with U3042. This only occured for BMP users testing with IMS & DB2 databases. I am investigating the issue, without much IMS support experience. [...]
Answer Question
| May 27, 2005 1:02 PM
DB2, Instant Messaging, OS/390, UDB for mainframe, z/OS
Reducing DISK I/O z/OS 1.4
I have a C loadmodule that is called 1000′s of times a day. The first action it takes is to open a PDS with 41 members and read them. This PDS’s members are only “text”, no load modules. I would like to know in what way I could cache them in memory and totally bypass [...]
Answer Question
| April 1, 2005 3:44 PM
z/OS, z/OS configuration, z/OS migration, z/OS optimization
I have a C loadmodule that is called 1000′s of times a day. The first action it takes is to open a PDS with 41 members and read them. This PDS’s members are only “text”, no load modules. I would like to know in what way I could cache them in memory and totally bypass [...]
Answer Question
| April 1, 2005 3:44 PM
z/OS, z/OS configuration, z/OS migration, z/OS optimization
IBM DB2 load restart
I am faced with a situation where my SYSREC file for a LOAD could potentially have duplicates. If there are dupes then I have a step that follows that analyses the SYSDISC file,so my DISCARDS is set to 0. If for whatever reason the utility blows up (ran out of space, whatever) and I choose [...]
Answer Question
| February 21, 2005 11:45 AM
DB2, OS/390, UDB for mainframe, z/OS
I am faced with a situation where my SYSREC file for a LOAD could potentially have duplicates. If there are dupes then I have a step that follows that analyses the SYSDISC file,so my DISCARDS is set to 0. If for whatever reason the utility blows up (ran out of space, whatever) and I choose [...]
Answer Question
| February 21, 2005 11:45 AM
DB2, OS/390, UDB for mainframe, z/OS
Scalar functions in GROUP BY
Is there a reason why I cannot use a SCALAR function in a Group BY clause? I have a table with a column that is of type timestamp. I want to get a count of all dates for which there are multiple rows. So I devise a query of the sort SELECT COUNT(*), DAYS(TMSTP_COL) FROM [...]
Answer Question
| October 21, 2009 2:15 PM
DB2, OS/390, UDB for mainframe, z/OS
Is there a reason why I cannot use a SCALAR function in a Group BY clause? I have a table with a column that is of type timestamp. I want to get a count of all dates for which there are multiple rows. So I devise a query of the sort SELECT COUNT(*), DAYS(TMSTP_COL) FROM [...]
Answer Question
| October 21, 2009 2:15 PM
DB2, OS/390, UDB for mainframe, z/OS
Oracle In Linux
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
DB2 Automated Utilities – Vendor selection
We use the IBM utilities suite and our own in-house utilities automation for DB2 v7. Our automated utilities is now draining us with heavy maintenance and since V7, there are still a few holes that could cause us some serious damage if not fixed in the near future. However, with V8, we would definitely have [...]
Answer Question
| June 4, 2004 11:08 AM
CIO, DB2, IT architecture, MVS, OS/390, OS/390/z/OS, UDB for mainframe, Vendors, z/OS
We use the IBM utilities suite and our own in-house utilities automation for DB2 v7. Our automated utilities is now draining us with heavy maintenance and since V7, there are still a few holes that could cause us some serious damage if not fixed in the near future. However, with V8, we would definitely have [...]
Answer Question
| June 4, 2004 11:08 AM
CIO, DB2, IT architecture, MVS, OS/390, OS/390/z/OS, UDB for mainframe, Vendors, z/OS
Encryption in the Database
Has anyone encrypted data in their Oracle/DB2/SQLServer databases? Can you share you experiences?
Answer Question
| May 13, 2004 2:18 PM
Oracle, OS/390, SQL Server, UDB for mainframe, z/OS
Has anyone encrypted data in their Oracle/DB2/SQLServer databases? Can you share you experiences?
Answer Question
| May 13, 2004 2:18 PM
Oracle, OS/390, SQL Server, UDB for mainframe, z/OS
DB2 Z/os IRLMWT parm
We are considering lowering the lockwait time from the two minute default to 60 seconds and then possibly even lower. What do you have it set to today? Have you had any experience with having it set well below one minute?
Answer Question
| May 14, 2004 1:33 PM
IBM, Instant Messaging, OS/390, OS/390/z/OS, UDB for mainframe, z/OS
We are considering lowering the lockwait time from the two minute default to 60 seconds and then possibly even lower. What do you have it set to today? Have you had any experience with having it set well below one minute?
Answer Question
| May 14, 2004 1:33 PM
IBM, Instant Messaging, OS/390, OS/390/z/OS, UDB for mainframe, z/OS
