I have a script that unlocks subscriptions. But if the subscription is already unlocked it errors out and stops processing at that line. I'd like to code such that if it is already unlocked, it should ignore the error and treat it as a warning and proceed to the next step. Whats the best way handling such conditions?
Thank you.

------------------------------
Manas Dasgupta
------------------------------


#DataIntegration
#DataReplication

Good day Manas: 

I don't know if this is the kind of answer you expect, but for having a better control on errors I will prefer to do it in Java.  There is an IBM Redbook plenty of programming samples: SG24-7941. It is quite old, but the techniques are basically the same.  In the <idr-install-path>/docs/api you will find the javadoc for the IDR java API.

Anyway, I hope someone has a better idea on how to manage errors in CHCCLP.

------------------------------
DANIEL JOSE LEMA GUANZIROLI
------------------------------

Thanks Daniel & Frank.

That's what I feared I'd have to do.

------------------------------
Manas Dasgupta
------------------------------

Original Message:
Sent: Thu May 14, 2020 07:32 PM
From: DANIEL JOSE LEMA GUANZIROLI
Subject: CHCCLP script - error handling

Good day Manas: 

I don't know if this is the kind of answer you expect, but for having a better control on errors I will prefer to do it in Java.  There is an IBM Redbook plenty of programming samples: SG24-7941. It is quite old, but the techniques are basically the same.  In the <idr-install-path>/docs/api you will find the javadoc for the IDR java API.

Anyway, I hope someone has a better idea on how to manage errors in CHCCLP.

------------------------------
DANIEL JOSE LEMA GUANZIROLI
------------------------------

Hello Manas

I think you have a couple of options outside of Java
1. In the current case. could you not simply break your chcclp script into 2 parts - one to just unlock and the second to do the rest of the processing? Then if the unlock fails because the subscription is not locked it does not matter because the 2nd script will kick in
2. If you are invoking your CHCCLP script from a shell script or batch script you could redirect output from chcclp to a file and then scan the file for any errors e.g. grep \[ERR and take appropriate action

------------------------------
Robert Philo
------------------------------

Original Message:
Sent: Fri May 15, 2020 06:55 AM
From: Manas Dasgupta
Subject: CHCCLP script - error handling

Thanks Daniel & Frank.

That's what I feared I'd have to do.

------------------------------
Manas Dasgupta
------------------------------


Original Message:
Sent: Thu May 14, 2020 07:32 PM
From: DANIEL JOSE LEMA GUANZIROLI
Subject: CHCCLP script - error handling

Good day Manas: 

I don't know if this is the kind of answer you expect, but for having a better control on errors I will prefer to do it in Java.  There is an IBM Redbook plenty of programming samples: SG24-7941. It is quite old, but the techniques are basically the same.  In the <idr-install-path>/docs/api you will find the javadoc for the IDR java API.

Anyway, I hope someone has a better idea on how to manage errors in CHCCLP.

------------------------------
DANIEL JOSE LEMA GUANZIROLI

I would then recommend to use embedded CHCCLP, invoked from Java. The class/method can then do the error handling of the CHCCLP script.

------------------------------
Frank Ketelaars
------------------------------

Hello If you do not want to use Java but you are invoking chcclp scripts from a batch file or shell script you have a couple of options

1) Break up your chcclp processing into 2 script
      a) The first script unlocks the table. If it errors because the table is already unlocked it does not matter
      b) The second script does the rest of the processing
2) More generally execute your chcclp script and check for any errors (scan string would be \[ERR in Linux/UNIX) Then you can code explicit recovery or user notification messages on detecting an error

------------------------------
Robert Philo
------------------------------

Thanks Robert. I have 4 subs and if the first one is already unlocked the processing ends there. So I have to break it down into 4 clp scripts just to be able to unlock successfully. I have run into same issue with "start mirror". Interestingly "end mirror" does not error out if the mirroring is already stopped for the sub.
Thanks,
Manas.

------------------------------
Manas Dasgupta
------------------------------

Original Message:
Sent: Fri May 15, 2020 02:21 AM
From: Robert Philo
Subject: CHCCLP script - error handling

Hello If you do not want to use Java but you are invoking chcclp scripts from a batch file or shell script you have a couple of options

1) Break up your chcclp processing into 2 script
      a) The first script unlocks the table. If it errors because the table is already unlocked it does not matter
      b) The second script does the rest of the processing
2) More generally execute your chcclp script and check for any errors (scan string would be \[ERR in Linux/UNIX) Then you can code explicit recovery or user notification messages on detecting an error

------------------------------
Robert Philo
------------------------------

Hi Manas,

Just a heads-up that there is a "wait" option for start mirror and end mirror. It wouldn't help with subs that are locked, but might help on other issues.

Here is the syntax:

[wait]                     Specifies how long to wait (in seconds) for 
                             mirroring to start/end before continuing with script 
                             execution. Use -1 to wait indefinitely, 0 for no 
                             wait, or maximum number of seconds to wait before continuing.
                             DEFAULT:
                                 0

------------------------------
SARAH ORVIS
------------------------------

Original Message:
Sent: Wed May 20, 2020 07:37 AM
From: Manas Dasgupta
Subject: CHCCLP script - error handling

Thanks Robert. I have 4 subs and if the first one is already unlocked the processing ends there. So I have to break it down into 4 clp scripts just to be able to unlock successfully. I have run into same issue with "start mirror". Interestingly "end mirror" does not error out if the mirroring is already stopped for the sub.
Thanks,
Manas.

------------------------------
Manas Dasgupta
------------------------------


Original Message:
Sent: Fri May 15, 2020 02:21 AM
From: Robert Philo
Subject: CHCCLP script - error handling

Hello If you do not want to use Java but you are invoking chcclp scripts from a batch file or shell script you have a couple of options

1) Break up your chcclp processing into 2 script
      a) The first script unlocks the table. If it errors because the table is already unlocked it does not matter
      b) The second script does the rest of the processing
2) More generally execute your chcclp script and check for any errors (scan string would be \[ERR in Linux/UNIX) Then you can code explicit recovery or user notification messages on detecting an error

------------------------------
Robert Philo