| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| 7.0.0.4: How to change the format of mqsilist date and time? |
« View previous topic :: View next topic » |
| Author |
Message
|
| t603 |
 Posted: Tue Feb 10, 2015 2:27 am Post subject: 7.0.0.4: How to change the format of mqsilist date and time? |
 |
|
Voyager
Joined: 16 Oct 2012
Posts: 88
Location: Prague, the Czech Republic, Europe
|
Hello,
I would like to know, how to change the format of date and time in mqsi commands like mqsilist. I need some computer ready-to-parse format like XSD datetime one or at least "yyyy-mm-dd hh:mm:ss.ssss".
I tried several experiments with locales, but with no luck. Below is my current configuration.
Thank You in advance for Your help, Stepan
AIX version
| Code: |
myServer:/home/mqsi $ oslevel
6.1.0.0 |
AIX installed locales
| Code: |
myServer:/home/mqsi $ locale -a
C
POSIX
cs_CZ.ISO8859-2@euro
cs_CZ.ISO8859-2@preeuro
cs_CZ.ISO8859-2
cs_CZ@euro
cs_CZ@preeuro
cs_CZ
en_US.8859-15
en_US.ISO8859-1
en_US |
AIX current active locale
| Code: |
myServer:/home/mqsi $ locale
LANG=cs_CZ
LC_COLLATE="cs_CZ"
LC_CTYPE="cs_CZ"
LC_MONETARY="cs_CZ"
LC_NUMERIC="cs_CZ"
LC_TIME="cs_CZ"
LC_MESSAGES="cs_CZ"
LC_ALL=cs_CZ |
AIX current active locale format
| Code: |
myServer:/home/mqsi $ locale -k d_t_fmt d_fmt t_fmt am_pm t_fmt_ampm
d_t_fmt="%a %e %b %Y %H:%M:%S"
d_fmt="%Y-%m-%d"
t_fmt="%H:%M:%S"
am_pm="";""
t_fmt_ampm="%H:%M:%S" |
Broker version
| Code: |
myServer:/home/mqsi $ mqsiservice -v
BIPmsgs cs_CZ
Console CCSID=912, ICU CCSID=912
Default codepage=ibm-912_P100-1995, in ascii=ibm-912_P100-1995
JAVA console codepage name=ISO-8859-2
BIP8996I: Version: 7004
BIP8997I: Product: WebSphere Message Broker
BIP8998I: CMVC Level: S700-FP04
BIP8999I: Build Type: Production, 64 bit, rios_aix_4 |
Broker mqsilist output (extract) - here is my problem:
| Code: |
BIP1288I: Message flow 'CONN_FMA_REQ' on execution group 'Connectors64' is running.
Deployed: '21.8.12 11:03' in Bar file '/home/mqsi/deploy/02_TSZ_DEV_CONN_FMA_REQ-BK1-Connectors64.bar'
Last edited: '17.8.12 17:26'.
|
|
|
| Back to top |
|
 |
| t603 |
| Posted: Tue Feb 10, 2015 2:33 am Post subject: |
|
|
Voyager
Joined: 16 Oct 2012
Posts: 88
Location: Prague, the Czech Republic, Europe
|
| Output of mqsilist to XML format would be of course better (something like mqsilist --format xml) with compliance of date, time and datetime (with or without time zones) XML Schema datatypes, but it is unfortunately out of scope now, I guess. |
|
| Back to top |
|
|
| zpat |
| Posted: Tue Feb 10, 2015 3:07 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
If you want programmatic access, try using the CMPAPI.
You could look at what mqsibackupbroker creates - I have no idea what it is in the zip file though.
_________________
Well, I don't think there is any question about it. It can only be attributable to human error. This sort of thing has cropped up before, and it has always been due to human error. |
|
| Back to top |
|
|
| t603 |
| Posted: Tue Feb 10, 2015 3:27 am Post subject: |
|
|
Voyager
Joined: 16 Oct 2012
Posts: 88
Location: Prague, the Czech Republic, Europe
|
| zpat wrote: |
| If you want programmatic access, try using the CMPAPI. |
I do not want any sophisticated access. I need just only get output from mqsilist date and time data types, which I can process in any programming languague (awk) and then to load to database or XML or...
Finally e. g. to merge with SVN log and dependency analysis to identify message flows affected by subflows changes commited after creation of deployed BARs.
Well, I hate any abbreviated date and time data formats. So much wasted time of parsing output just because of saving century two characters and leading zeros everywhere. Moreover switched months and days... Ufff! Sorting from years to millisecond sounds so natural for me. |
|
| Back to top |
|
|
| t603 |
| Posted: Tue Feb 10, 2015 4:03 am Post subject: |
|
|
Voyager
Joined: 16 Oct 2012
Posts: 88
Location: Prague, the Czech Republic, Europe
|
But e. g. mqsiservice display output in wanted format, see below. So why mqsilist outputs different format of date and time?
| Code: |
myServer:/home/mqsi $ mqsiservice BK1 -t
BIPmsgs cs_CZ
Console CCSID=912, ICU CCSID=912
Default codepage=ibm-912_P100-1995, in ascii=ibm-912_P100-1995
JAVA console codepage name=ISO-8859-2
ICU Version: 3.8.1
ICU TZ Data Version: 2011n
Current Local time: 2015-02-10 12:59:25.307968
Current UTC time: 2015-02-10 11:59:25.308144
Env TZ: CET-1CEST,M3.5.0,M10.5.0
ICU TimeZone ID: CET
Standard offset from GMT: 60
Supports DST? true
Locating DST boundaries
GMT Local DST Mins
2015-01-01 13:00:00 2015-01-01 14:00:00 0
2015-03-28 13:00:00 2015-03-28 14:00:00 0
2015-03-29 13:00:00 2015-03-29 15:00:00 60
2015-10-24 13:00:00 2015-10-24 15:00:00 60
2015-10-25 13:00:00 2015-10-25 14:00:00 0
Day Names: ned▒le, pond▒l▒, ▒ter▒, st▒eda, ▒tvrtek, p▒tek, sobota,
Month Names: ledna, ▒nora, b▒ezna, dubna, kv▒tna, ▒ervna, ▒ervence, srpna, z▒▒▒, ▒▒jna, listopadu, prosince,
First day of week: 2
Days in first week of year: 1
AM: dop. PM: odp.
Install Path = /opt/IBM/mqsi70
Shared Work Path = NOT_HA_ENABLED_BROKER
Local Work Path = /var/mqsi
Component UUID = 4119fd7b-1901-0000-0080-8d9c229c8a40
process id = 44761226
broker db userId = ***
broker db password = ***
queue manager = BK1.QM
pubsub migration = no
fastpath Queue Manager = no
configuration timeout = 360
configuration delay timeout = 180
statistics major interval = 60
ComponentType = Broker
Fixpack capability level = 6.1.0.9 (effective level 7.0.0.1)
|
|
|
| Back to top |
|
|
| t603 |
| Posted: Tue Feb 10, 2015 4:13 am Post subject: |
|
|
Voyager
Joined: 16 Oct 2012
Posts: 88
Location: Prague, the Czech Republic, Europe
|
| zpat wrote: |
| You could look at what mqsibackupbroker creates - I have no idea what it is in the zip file though. |
Output of mqsibackupbroker does not look promising. Although it is in XML, dates and times are correctly formatted, but the most of data are in some hexa format. Files "deployinfo.dat" has one date and time for different mxsds and jars, who (IBM) knows, what these data and time means. Moreover to unzip hundreds of megabytes...
Anyway thank You for hint, I am glad for any help from anyone. |
|
| Back to top |
|
|
| t603 |
| Posted: Thu Mar 19, 2015 3:17 am Post subject: |
|
|
Voyager
Joined: 16 Oct 2012
Posts: 88
Location: Prague, the Czech Republic, Europe
|
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Mar 19, 2015 3:23 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
There is (AFAIK) another RFE that is for a feature that would get all the params of a broker and put it into an XML File. That would probably meet your requirement as well.
Ideally, the XML file could be fed into a create utility to build a new broker as an exact replica of the old one. Perfect for cloud operations IMHO.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| t603 |
| Posted: Thu Mar 19, 2015 3:55 am Post subject: |
|
|
Voyager
Joined: 16 Oct 2012
Posts: 88
Location: Prague, the Czech Republic, Europe
|
| smdavies99 wrote: |
| There is (AFAIK) another RFE that is for a feature that would get all the params of a broker and put it into an XML File. That would probably meet your requirement as well. |
...Yes, this RFE (about XML output for get and set) is also (another) my RFE  It can be seen on http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=40438. Unfortunately it does not look like it will be implemented in IIB 10. So maybe IIB 11.
And You are right, all is about similar things - parseable output. But I hope, that output of date, time, dateTime into XML will respect formatting as defined in XML Schema date types and will not be free text (string)  |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
