How to convert these IMS unload files from EBCDIC to UTF-8 encoding.

Dear Micael and all Thank you very much for your response and the valuable information provided. Over the past few days, I discussed the DBD definitions with our IMS DBA, and we have a similar setup where “The only fields that are required to be defined in a DBD are the keys, indexed

Re: Assistance with Converting IMS DB to MySQL DB

. Thank you very much for your help! Best regards, Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Assistance with Converting IMS DB to MySQL DB

await your response and look forward to benefiting from your guidance. Best regards, Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM

Inquiry Regarding Sudden Increase in DFSMSrmm CDS Utilization

be looking into to identify the potential cause of this issue in the RMM journal? We would greatly appreciate any suggestions or recommendations that you could provide. Thank you in advance for your time and assistance. Kind Regards, Jason Cai

Re: Consultation on the Potential Risks of Deleting Specific Datasets

A safer approach would be to alter the mgmt. class to (e.g. delete after 1 year of non use). -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO

Re: [EXTERNAL] Re: Consultation on the Potential Risks of Deleting Specific Datasets

of these datasets. Is my understanding correct? Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Consultation on the Potential Risks of Deleting Specific Datasets

datasets targeted for deletion. Could you please provide detailed steps or direct me to the relevant documentation that could assist me in executing this task? Any additional tips or best practices you could share would also be greatly appreciated. Thank you for your time and assistance. Jason Cai

Re: Consultation on the Potential Risks of Deleting Specific Datasets

Dear The phrase ‘Delete the dataset, however, and you will end up with a JCL error’ is not entirely clear to me. Could you please provide an explanation? If I attempt to delete a dataset with the attribute ‘lastref=none’ using JCL, will it result in an error? Thanks a lot! Jason Cai

Consultation on the Potential Risks of Deleting Specific Datasets

response. Best regards, Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

How to keep the act upon mode unchanged for 1 minute in MSGFLDxx

if there is any way to keep the act upon mode unchanged for 1 minute. Any suggestions is highly appreciated! Thank you! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...

Question about RMF III Device Resource Delay

ions would be greatly appreciated! Thank you for your attention and assistance. Sincerely, Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Inquiry about extracting and counting msgid from operlog using sort program

it to fit my specific needs. Thank you again for your assistance. You are very kind and professional. Best Regards, Jason Cai == Jason, for you first question I could say experience. All my customer sites have different "hot messages" to look

Re: Inquiry about extracting and counting msgid from operlog using sort program

Analytics and IBM Z Anomaly Analytics with Watson. Are these tools free or do they require a license fee? How can I get access to them if I want to try them out? Thanks a lot! Jason Cai == Found it. The tool that should do what you want, with a bit

Re: Inquiry about extracting and counting msgid from operlog using sort program

wonder how your shop handles this situation. The second question is a simplified one. Can dfsort delete the last word if the first position is M and the last word is a number? I appreciate your time and attention. Sincerely, Jason Cai

Re: Inquiry about extracting and counting msgid from operlog using sort program

ine 423.. I want to delete 423 of the first line. REXX processing is very easy but too slow because my operlog for one day is very large. Can sort or other tools handle it? Any suggestions is greatly appreciated Jason

Inquiry about extracting and counting msgid from operlog using sort program

'),AND, (67,1,SS,EQ,C'ABCDEFGHIJKLMNOPQRSTUVWXYZ')) But I do not know how to count the number of occurrences of each msgid and eliminate duplicates. Thank you for your time and attention. Sincerely, Jason Cai -- For IBM-MAIN

which configuration members were used when a zos system ipl

Hi all I need to know which configuration members were used when a zos system IPL, of course I can confirm them one by one with my eyes, is there any other way to find them faster such as tools, rexx code and what good ideas. Any suggestions are greatly appreciated. Thanks a lot! Jason Cai

A question about IXGLOGR and RRS CPU usage

also increased significantly, but the RRS CPU usage is not high. Is this normal? I would like to know how to reduce the IXGLOGR CPU usage. Any suggestions are greatly appreciated. Thank you for your time and attention. I look forward to hearing from you soon. Sincerely, Jason Cai

A question about CPU usage on z/OS

. Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: IEF211I

Hi Kolusu Thanks for your reply ! We will print this smf type today. Jason Cai -- For IBM-MAIN subscribe / signoff / archive access

Re: IEF211I

HI Shmuel DSN is an alias name(a loadlib dataset). Could you tell me how to find which another user reserved this alias? Thanks a lot! Jason Cai

IEF211I

Hi all Production job gets this message - IEF211I jobname [procstep] stepname ddname[+ xxx] - DATA SET RESERVATION UNSUCCESSFUL Could you tell us which SMF type could diagnose this problem? Thanks a lot Jason Cai

Is there any way to reserve a primer DASD or a secondary DASD?

Hi all We want to do some testing for MIH and DASD Long Busing. Is there any way to reserve a primer DASD or a secondary DASD? Any suggestions are highly appreciated! Thanks a lot! Jason Cai -- For IBM-MAIN subscribe

Whether MSGFLD handle IOS050I,SUP(NO) in MPFLST.

MSG IOS050I NOLOG,NOAUTO,NODISPLAY,NORETAIN,NOIGNORE Could you tell us whether MSGFLD will handle ISO050I message or not ? What is diffenent for MSGFLD between SUP(YES) and SUP(NO) msgid in MPFLST? Thanks a lot! Jason Cai

how long will wait to vary the bad path offline

Hi all We had a situation with a bad FICON Director that resulted in a huge performance impact due to the default way that z/OS handles error recovery on FICON paths. The symptoms were many (thousands) of IOS050I or IOS051I messages in the task's joblog, followed by IOS001E,

more locks in IRLM

Hi all If there are more locks in IRLM by TRANS, will it make CICS address space or DB2 address space CPU increases or decrease? Any suggestions is great appreciated! Thanks a lot! Jason Cai -- For IBM-MAIN subscribe

How to reconfigure the STP role by HMC or By GDPS

? Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: how to IPL z/OS by JCL

Hello Steve Thanks for your help! We have other three questions : Q1. Could we load all z/OS LPARs at the same time? Q2.If the anwser to Q1 is no, how to load the lpar one by one in one script/jcl? Thanks a lot! Jason Cai

how to IPL z/OS by JCL

HI all In our shop, there are many z/OS members with GDPS and SA. we need to logon HMC to IPL z/OS members Could you tell us how to IPL z/OS by JCL or script? Any suggestions are highly appreciated! Thanks a lot! Jason Cai

Re: How to monitor all red messages

Hello Steve Thanks for your reply! Best Regards, Cai Jin Song -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

How to monitor all red messages

If we want to monitor a special message, we could specify the message-id in SA. Could you tell us how to define all red messages in SA? Any suggestions are highly appreciated! Thanks a lot! -- For IBM-MAIN subscribe / signoff

Re: How to simplify IODF activation

>I would write an ISPF script using file tailoring to submit 20 jobs, and test >everything very thoroughly before going live. Hello Metz Thanks for your reply! Could you give me a sample for the ISPF script ? Thanks a lot! Jas

Re: How to simplify IODF activation

Could you give me a sample FTP JCL to submit the activating IODF JCL? I have an other question: How to verify whether the activating IODF JOB is successful or not after it is submitted? Thanks a lot! Jason Cai -- For

How to simplify IODF activation

Hi all In our shop, there are more than 20 single image systems. When we want to activate a production IODF, we have to logon to these 20 systems. Could we logon to one z/OS system to submit JOBs to activate the IODF for these 20 systems. Any suggestions are greatly appreciated!!! Thanks

Re: How to get APAR number

Thanks all for your suggestions! If we have a lot of PTF numbers,is there any way to get APAR numbers relation to these PTFs quickly? Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions

How to get APAR number

Hi all If we know a PTF number, how to get the APAR number relation to the PTF number ? Any suggestion is greatly appreciated! Thanks a lot ! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions

is there any document for using shopz

Hi all I just am authorized to access IBM shopz. I had never accessed IBM shopz before. Is there any document about how to order production or PTF by shopz. Any suggestion is greatly appreciated! Thanks a lot! Jason Cai

Re: HOW to use dfsort to replace these dates and times with BLANK

,but the performance is bad. Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

HOW to use dfsort to replace these dates and times with BLANK

z/OS from 2.2 to 2.3 . Any suggestions are highly appreciated! Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: How to use dfsort to filter keywords that aren't fixed position

Hello Steve Log Analysis Program is free? Could you tell us where we could download it? I could not find the download website for it. Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access

Re: How to use dfsort to filter keywords that aren't fixed position

line for operlog(2) and operlog(3), we could compare them. Question4 : After comparing them , how to split a single line into multiple lines? Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access

Re: How to use dfsort to filter keywords that aren't fixed position

Hello Kolusu Q1 How to use DFSORT to select the first duplicate of multi-line messages in Syslog Below are multi-line messages from SYSLOG (PUSH=(140:ID=9)) INPUT Organization . . . : PSRecord format . . . : FB Record length . . . : 149

Re: How to use dfsort to filter keywords that aren't fixed position

Hello Kolusu and all There are many duplicates multi-line messages in Syslog Could you tell us: 1 How to use DFSORT to select the first duplicate of multi-line messages in Syslog 2. How to use DFSORT to compare two the Syslog depending on multi-line messages. Thanks a lot！ Jason Cai

Re: How to use dfsort to filter keywords that aren't fixed position

Thanks for Kolusu and Massimo's help We used the following JCL to filter 'CHECK' and 'ERROR' keywords. It is fine. Is there an easy way to filter many keywords if we have many keywords? For example: Can we put these keywords in a dataset? Thanks a lot! Jason Cai

Re: How to use dfsort to filter keywords that aren't fixed position

Thanks for Martin, Massimo, and Kolusu's help As Massino mention that a multiline WTO cannot be interrupted, we need to handle multiline messages in OPERLOG or SYSLOG that cannot be interrupted. for IBM manul Each SYSLOG record is prefaced by a two-character record type field. Valid first

How to ignore dates and times depend on their format before comparing them

the dates and times are. I could write a rexx to ignore it. In this way I need to write a lot rexx for each DISPLAY command depend on their position. Is these any way to ignore these dates and times depend on their format (-MM-DD and HOUR.MINUTES.SECOND)? Thanks a lot! Jason Cai

Re: how to compare active parameter with the parameter in member

Dear ITschak It is great that you do that in your production! I couldn't find Lionel Dyke's IPLINFO,could you tell where I can down it? You are right that we need to parse the the output from the display and compare same value in the parmlib. I know some Python . In Python we could

Re: how to compare active parameter with the parameter in member

Dear all You gave me many good ideas,many thanks! We want to develop this tool to compare them. Depend on system and subsystem,we could issue many D or $D command. Because there are mash of these output and the format of output is different with the parmlib members,how to compare

how to compare active parameter with the parameter in member

Regards, Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: part of TSO commands are no RESPONSE from PGM=IKJEFT01

Hi The part of output is correct. the others of output is empty. Whether there are a lot of XQUERY in one job? Best Regards, Jason Cai From: Hobart Spitz Date: 2019-03-25 21:14 To: IBM-MAIN Subject: Re: part of TSO commands are no RESPONSE from PGM=IKJEFT01 I think you need to give us

Moving a Catalog to a Different Volume

to confirm that the original catalog in the old volume is the same as the catalog in new volume Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu

Re: part of MVS commands are no RESPONSE from REXXCDM

I try to get the output of these mvs commands and save these output to a DSN. Best Regards, Jason Cai From: Steve Beaver Date: 2019-03-25 09:38 To: IBM-MAIN Subject: Re: part of MVS commands are no RESPONSE from REXXCDM Have you tried to open a console? Sent from my iPhone Sorry

part of TSO commands are no RESPONSE from PGM=IKJEFT01

DATASET('xxx.TST') DISP(MOD) VOLUME(BJ2917) DETAIL We found there are just part of this commands responsed. Any thoughts/comments/suggestions would be greatly appreciated Best Regards, Jason Cai -- For IBM-MAIN

part of MVS commands are no RESPONSE from REXXCDM

would be greatly appreciated Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Each alias belongs which storage group

Yes we assign Storage Groups based on aliases in your ACS routines. Because there are so many alias in our system,is there a way to get the relationship by batch? Thanks a lot! Best Regards, Jason Cai There is no relationship between aliases and Storage Groups, unless you assign Storage

how to get the address and size(cylinders) for each volume

Hi all Is there a utility to get the address and size(cylinders) for each volume? Thanks a lot! Best Regards, Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists

Each alias belongs which storage group

Hi all There are many catalog in our shop. There are also many alias in each catalog. Could you tell how to know each alias belongs to which storage group ? Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff

Re: descriptor code for iplcheck

Hi Steve and all Could you give us a sample program in REXX or assemble how to extract descriptor code by MDBG Thanks a lot! Best Regards, Jason Cai From: Steve Horein Date: 2018-11-08 20:44 To: IBM-MAIN Subject: Re: descriptor code for iplcheck https://www.ibm.com/support

Re: filter program

MSGID If we use SORTs Or "ISREDIT find",we don't know how to extract multiple-line message Could you tell us how to use SORTs can extract on 'anything' using control cards or "ISREDIT find" any suggestions is very appreciated Best Regards, Jason Cai From: John Kelly

Re: descriptor code for iplcheck

Code: 3 Could you tell us Where we could find the descriptor code in oplerlog? Thanks a lot! Best Regards, Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu

Re: filter program

Hi This is a good idea. We use ADDRESS ISREDIT to filter the PS . Thanks again! Best Regards, Jason Cai From: retired mainframer Date: 2018-11-08 01:38 To: IBM-MAIN Subject: Re: filter program In ISPF, edit the dataset or file, then X ALL followed by F filter-text ALL

filter program

a lot! Best Regards, Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: descriptor code for iplcheck

Hi Steve You are right. I found it . Descriptor Code Type Code 1 W (wait) 2 A (action) or D (decision) 3 E (eventual action) 4 through 10 I (information) 11 E (eventual action) 12 and 13 I (information) Thanks a lot! Best Regards, Jason Cai From: Jason Cai Date: 2018-11-07 09:13

Re: descriptor code for iplcheck

Code: 3 Where we could find the descriptor code in oplerlog? Thanks a lot! Best Regards, Jason Cai From: Steve Horein Date: 2018-11-07 08:45 To: IBM-MAIN Subject: Re: descriptor code for iplcheck Maybe this? https://www.ibm.com/support/knowledgecenter/SSLTBW_2.2.0/com.ibm.zos.v2r2.ieam100

descriptor code for iplcheck

code don't support SYSLOG . Our questions: 1. If we want to process each member,how to get descriptor code from syslog? 2. everyday we backup our operlog, how to get descriptor code from it? any other way to check the system after IPLed. Thanks a lot! Best Regards,

define a service class in wlm by batch

Hi all Could we define a service class in WLM by batch job? Thanks a lot! Best Regards, Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message

how to create a mini IPLable system

Hi all If a single image zos system can't be IPLed,we want to IPL other system to rescue it, Could you tell us how to create a mini IPLable system? Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive

how to suppress the appliction highlighted console messages

the appliction highlighted console messages Thanks a lot! Best Regards, Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

migrate from GDPS 3.12 to GDPS metro 4.1.

migration documentation for reference? Any thoughts/comments/suggestions would be greatly appreciated! Thanks a lot! Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists

arm police

by arm after issuing cancel db2.How to do it? Thanks a lot!Jason Cai -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

ESQA is exhausted

Hi all We found that ESQA is exhausted, it overflow to ECSA.We want to enlarge ESQA and ECSA . Because the common area is enlarged,the private area will be decreased. We wonder whether there is any risk to enlarge common area ? Thanks a lot! Jason Cai

Re: How to reduce batch job's negative impact on the online transaction response time

Our environment : z/OS 1.13 +CICS 4.2(online system) +DB2 10.1 We don't use any web based functions.We aslo use WLM to classify all the service class under which production CICS runs as CPU CRITICAL. problem description: There will be some batch job which will update/insert

How to reduce batch job's negative impact on the online transaction response time

Hi all Our shop is parallel system.We have some batch jobs which have to run in online window. Could you have any good experiences or ideas to reduce the batch job's negative impact on the online transaction response time ? . Thanks a lot!