Showing posts with label Commands. Show all posts
Showing posts with label Commands. Show all posts

Wednesday, October 26, 2016

MQ Linux Commands

The majority of these commands are run as the mqm (or equivalent) user. By default these commands are in /opt/mqm/bin which I would advise adding to the mqm users PATH.

Create a Queue Manager

$ crtmqm REPLACE_QMGR_NAME

Delete a Queue Manager

$ dltmqm REPLACE_QMGR_NAME

Start Queue Manager

$ strmqm REPLACE_QMGR_NAME

Stopping Queue Manager

Wait for queue manager to shutdown
$ endmqm -w REPLACE_QMGR_NAME

End Immediately
$ endmqm -i REPLACE_QMGR_NAME

Start Queue Manager (Init Script)

By default Websphere MQ does not ship with an init script, you can add this functionality via a support pac (MSL1) provided by IBM.
$ service ibm.com-WebSphere_MQ start

Stopping Queue Manager (Init Script)

$ service ibm.com-WebSphere_MQ stop

Start MQ Listener

$ echo "start LISTENER(SYSTEM.DEFAULT.LISTENER.TCP)" | runmqsc REPLACE_QMGR_NAME

Stop MQ Listener

$ echo "stop LISTENER(SYSTEM.DEFAULT.LISTENER.TCP)" | runmqsc REPLACE_QMGR_NAME

Display Queue Managers & Status

$ dspmq

Set MQ Privileges

In order for a Unix user to start utilizing MQ they must have the appropriate privileges. You can find the available privileges in IBM's Documentation.
Set MQ Privileges By User
$ setmqaut -m REPLACE_QMGR_NAME -t qmgr -p REPLACE_USER REPLACE_PLUS_OR_MINUS_PRIVILEGE

Set MQ Privileges By Groups
$ setmqaut -m REPLACE_QMGR_NAME -t qmgr -g REPLACE_GROUP REPLACE_PLUS_OR_MINUS_PRIVILEGE

Display MQ Privileges

Display MQ Privileges By Users
$ dspmqaut -m REPLACE_QMGR_NAME -t qmgr -p REPLACE_USER

Display MQ Privileges By Groups
$ dspmqaut -m REPLACE_QMGR_NAME -t qmgr -g REPLACE_GROUP

Lookup MQ Error Numbers

$ mqrc REPLACE_ERROR_NUM

MQ Sample Scripts

Within the MQ release by IBM there is a package that contains sample scripts for MQ. There are about 3 of these sample scripts that I have found pretty useful.
Pop (GET) Messages off a queue
$ amqsget REPLACE_Q_NAME REPLACE_QMGR_NAME

This command will remove messages from the queue, only use this if you no longer want the messages in the queue.
Browse Messages in a queue
$ amqsbcg REPLACE_Q_NAME REPLACE_QMGR_NAME

Open a Queue for writing
$ amqsput REPLACE_Q_NAME REPLACE_QMGR_NAME

When you find yourself with a system that is connected to a repository but doesn't see new messages you can try opening the queue for writing with amqsput to "refresh" the connectivity. You do not have to write anything to the queue. Simply open the queue and press ctrl+d without typing any additional characters.

Open Websphere MQ CLI

$ runmqsc REPLACE_QMGR_NAME

Websphere MQ CLI Commands

The following commands are to be run directly from the MQ command line interface.

Start MQ Listener

start LISTENER(SYSTEM.DEFAULT.LISTENER.TCP)

Stop MQ Listener

stop LISTENER(SYSTEM.DEFAULT.LISTENER.TCP)

Disable Channel Authentication

alter qmgr chlauth(disabled)

Channel Authentication is new as of MQ 7.0. If your systems don't use it you can simply turn it off.

Display Queues

All Queues
display queue(*)

Specific Queues
display queue(REPLACE_Q_NAME)

Short hand
dis q(REPLACE_Q_NAME)

Display Local Queues only

All Queues
display qlocal(*)

Specific Queue
display qlocal(REPLACE_Q_NAME)

Short hand
dis ql(REPLACE_Q_NAME)

Display Alias Queues only

All Queues
display qalias(*)

Specific Queue
display qalias(REPLACE_Q_NAME)

Short hand
dis qa(REPLACE_Q_NAME)

Display Cluster Queues only

All Queues
display qcluster(*)

Specific Queue
display qcluster(REPLACE_Q_NAME)

Short hand
dis qc(REPLACE_Q_NAME)

Display Channels

All Channels
display channel(*)

Specific Channel
display channel(REPLACE_CHANNEL_NAME)

Short hand
dis channel(REPLACE_CHANNEL_NAME)

Display Channel Status

All Channels
display chstatus(*)

Specific Channel
display chstatus(REPLACE_CHANNEL_NAME)

Short hand
dis chstatus(REPLACE_CHANNEL_NAME)

Display Local Queue Manager Information

display qmgr

Display Cluster Queue Manager Information

display clusqmgr(REPLACE_CLUSQMGR_NAME)

Show number of INPUT and OUTPUT threads open

display qstatus(REPLACE_Q_NAME) IPPROCS OPPROCS

Find Process ID of Processes Accessing Queue

display qstatus(REPLACE_Q_NAME) TYPE(HANDLE) ALL

Refresh Cluster Queue Manager

refresh cluster(REPLACE_CLUSQMGR_NAME)

Start Channel

start channel(REPLACE_CHANNEL_NAME)

Tuesday, October 25, 2016

WebSphere(IIB) MQSI Commands and Syntax


1.Mqsisetdbparams


      Mqsisetdbparms–brokername– -n –DataSourceName
-u –DataSourceUserId– -p –DataSourcePassword

To delete the set dbparams command 


Mqsisetdbparms–brokername– -n –DataSourceName


2.mqsisetcapacity 
The mqsisetcapacity command to set the number of valid product licenses on your system.
mqsisetcapacity -c n
where n is the number of valid licences
3. mqsilistaclgroup

      Use the mqsilistaclgroup command to view or list the currently defined:
  • User groups
  • Users
  • Objects
  • Access control lists
mqsilistaclgroup--+--------------------+--------------------><
                     +- -g --GroupName ---+
                     +- -u --UserName ----+
                     +- -b --Broker-------+
                     +- -e --ExeGroup-----+
                     +- -s --Subscription-+
                     +- -r root topic---------+
‘- -t —————
4.mqsidisplaycapacity
The mqsidisplaycapacity command to display the number of valid product licenses and the processor count values on the system
Mqsidisplaycapacity
5.mqsideploy

mqsideploy command to make a deploy request to the Configuration Manager
mqsideploy –b broker name – complete  delta/complete –topic topic name –topology                      topology name -cancel –r –w timeoutValue – connection  connection filename –e   execution  groupname –bar bar file name  -rmMsgFlow name
6.mqsideleteaclgroup
The mqsideleteaclgroup command to delete the Configuration Manager database table relating to the group or user access control lists that you have defined
Mqsideleteaclgroup –f filename –g groupname –u username –b broker name –e exegroup –s subscription –r –t filename: File from which to import the configuration. The output of the mqsilistaclgroupcommand is    the correct format
7.Mqsicustomize
Mqsicustomize command to customize the broker from the root directory of your broker,  for example,     /var/wmqi/MQP1BRK.This command is supported
8.Mqsicreatemsgdefs

    This command is used to create the message defination files in ma message sets
Syntax is
    Mqsicreatemsgdefs -p  -d <c:\myproject\source>   -rmp -rmd

9.mqsicreatebar
The mqsicreatebar command provides a command line compiler that creates deployable broker archive files containing message flows and dictionaries.
Syantax
Mqsicreatebar –data  workspacepath –b barfile –version vesionstring –p projectname –o file path
In the above command barflies and file path are required attributes.
10.mqsichangeflowstats
The mqsichangeflowstats command to:
  • Turn on or off accounting and statistics snapshot publication, or archive record output.
  • Specify that the command be applied to a specific flow message flow, or all flows in an execution group, or all execution groups belonging to a broker.
  • Modify the granularity of the data collected in addition to the standard message flow accounting and statistics. This extra data can include thread related data, node related data, node terminal related data, or a mixture of this data.
Sample command
Mqsichangeflowstats BrokerA -s -g -j -b none
11.mqsireportflowstats
       mqsireportflowstats command to display the current options for accounting and statistics that have been set using themqsichangeflowstats command
mqsireportflowstars –reportflowwstars –a=yes –rs –s

PUBLISH/SUBSCRIBE COMMANDS

12.Mqsiclearmqpubsub
The mqsiclearmqpubsub command to remove an MQSeries Publish/Subscribe broker as a neighbor of this WebSphere Business Integration Event Broker broker.
Syntax
Mqsiclearmqpubsub – brokername –n neighborqueuemanagename

 13.mqsijoinmqpubsub
The mqsijoinmqpubsub command to join this WebSphere Business Integration Event Broker broker to an Miseries Publish/Subscribe broker network. The command identifies a specific Miseries Publish/Subscribe broker to be the parent of the WebSphere Business Integration Event Broker broker
Syntax

Mqsijoinmqpubsub –brokername –p –parentQueueManagerName
14.Mqsilistmqpubsub
The mqsilistmqpubsub command to display the status of the Miseries Publish/Subscribe neighbor brokers to the specified WebSphere Business Integration Event Broker broker
Syntax
Mqsilistmqpubsub–brokername.

Migration commands

15.Mqsimigratemsgflows
The mqsimigratemsgflows command to create new flows in the WebSphere Business Integration Event Broker V5.0 format, based on existing exported flows from a WebSphere MQ Event Broker V2.1 Configuration Manager.
Mqsimigratemsgflows –data workspacepath –p projectname –d directoryname –rm –log logfilename
16.mqsimigratemsgsets
The mqsimigratemsgsets command imports all the files with the extension .mrp in the directory specified by the -d parameter. Files with any other extension are ignored.
Syntax
Mqsimigratemsgsets –d , -d ata workspace –rm –g –log -v
17.Mqsimigratetables
The mqsimigratetables command to migrate the database tables for brokers or the Configuration Manager.
Syntax
Mqsimigratetables –brokername  -I serviceuseid –a service password
Mqsimigratetables –Configmgr  -I serviceuseid –a service password
Properties commands

Mqsichangeproperties,Mqsireportproperties
Trace Commands
18.Mqsichangetrace
The mqsichangetrace command to set the tracing characteristics for a component
Syntax
usertrace
Mqsichangetrace – borker name u – e executiongroupname –f flow –r –l level – m mode –
Service trace
Mqsichangetrace – borker name -t – e executiongroupname –f flow –r –l level – m mode
19.mqsiformatlog
The mqsiformatlog command to process the XML log created by mqsireadlog.
Syntax
Mqsiformatlog –I inputfilename –o outfilename.
20.Mqsireadlog
The mqsireadlog command to retrieve the trace log for the specified component
mqsireadlog –componet –u –e egroup –f flowname–o outfilename
21.mqsireporttrace
The mqsireporttrace command to display the trace options currently in effect. This command is valid for:
syntax


mqsireporttrace –componet –u –e egroup –f flowname –o outfilename
22.Mqsicreateusernameserver

This command is used to create the usename server





Mqsicreateusernameserver –I service userid –a servicepassword –q queuemanagername –r intervel 
23.Mqsichangeusernameserver

Mqsichangeusernameserver command to change various properties of the User Name Server.
24.Deleteusernameserver


Deleteusernameserver is used to delete the usenameserver
ConfigManager Commands
25.MqsicreateConfigMgr

      Syntax>>-mqsicreateconfigmgr– -i –ServiceUserID –a serviecpassword –q queuemanagername –n databasename –u databaseuserid –p databasepassword –d securitydomainname –s username serverqueumanagername –w work path
26.MqsichangeconfigMgr
 syntax
MqsichangeconfigMgr – a servicepassword –I serviceuserid –p databasepassword –g usernameserver queuemgrname –d securitydomainname –j maxjvmheapsize
Broker Commands
27.Mqsicreatebroker

Syntax

Mqsicreatebroker brokername –I serviceuserid –a servicepassword –q queuemanagername –n datasourecname –u datasourecuserid –p datasourcepassword –s unsqm -w workpath –l userlilpath –g configurationtiemout –p http port
28.Mqsichangebroker
Syntax
Mqsicreatebroker brokername ––a servicepassword I serviceuserid   –p datasourcepassword –s unsqm -w workpath –l userlilpath –g configurationtiemout –p http port
29.Mqsidelteborker

Syntax
Mqsideletebroker brokername
30 .Mqsireload
the mqsireload command to request the broker to stop and restart execution groups.
Syntax
Mqsireload brokername –egroup
31.mqsicbrreport
The mqsicbrreport command to help identify applications that use a content-based routing filter. The program inspects a broker’s subscriptions table, and reports any filters it finds that might cause incompatible behavior.
Syntax
Mqsicbrreport brokername
32.Mqsideleteconfigmg
Syntax mqsideleteconfigMgr

Tuesday, October 11, 2016

Trace Commands

mqsichangetrace MDBKRQB05 -u -e OTHERS -f I2208_ORACLE_APINVOICEFEBACK_OAG -c 1400000 -r -l debug

mqsireadlog MDBKRQB05 -u -f -e OTHERS -o D:\wmb\i2208_LOGFILE.xml

mqsiformatlog -i D:\wmb\i2208_LOGFILE.xml -o D:\wmb\i2208_LOGFILE_OUTPUT.xml



mqsichangeproperties BDBKRDB01 -e  Ave -o HTTPSConnector -n port -v 7844


mqsireportproperties MDBKRDB05 -e I2150 -o HTTPSConnector -a



mqsireportproperties AB300D001 -o AllReportableEntityNames -r -b httplistener



mqsisetdbparms BrokerName -n sftp::SecurityIdentityName -u UserName -p Password
mqsicreateconfigurableservice BrokerName -c FtpServer -o Configservicename -n serverName,securityIdentity -v ActualserverName,SecuirityIdentityName


MQSILIST
MQSISTOP -I BROKERNAME
MQSISTART BROKERNAME



dspmq
runmqsc
crtmqm



Right Command to change httplistener:


mqsichangeproperties MDBKRDB05 -b httplistener -o HTTPConnector -n port -v 7082



mqsichangetrace BDBKRDB01 -u -e INT3000-INT3999 -f I3065_FTPC_GENEVA_STACKTRANS_EISERVICE -c 1400000 -r -l debug

mqsireadlog BDBKRDB01 -u -f -e INT3000-3999 -o /var/ibm/i3605_LOGFILE.xml

mqsiformatlog -i D:\wmb\i2208_LOGFILE.xml -o /var/ibm/i3605_LOGFILE_OUTPUT.xml



mqsireportproperties AB300D001 -o AllReportableEntityNames -r -b httplistener


mqsireportproperties BDBKRDB01 -e INT3000-INT3999 -o HTTPSConnector -a


mqsichangeproperties BDBKRDB01 -e INT3000-INT3999 -o HTTPConnector -n port -v 7845
mqsichangeproperties BDBKRDB01 -b httplistener -o HTTPConnector -n port -v 7080



mqsireportproperties BDBKRDB01 -b httplistener -o HTTPConnector -n port -v 7082

mqsistopmsgflow BDBKRDB01 -e INT3000-INT3999

mqsistartmsgflow BDBKRDB01 -e INT3000-INT3999

mqsireportbroker BDBKRDB01
mqsistopmsgflow BDBKRDB01 -e INT3000-INT3999 -f I3065_FTPC_GENEVA_STACKTRANS_EISERVICE



once done trace, disable using level: -l none


Fiinal working command to stop flow
mqsistopmsgflow BDBKRDB01 -e INT3000-INT3999 -m I3065_FTPC_GENEVA_STACKTRANS_EISERVICE

-m for the message flow....


mqsireportproperties BDBKRDB01 -b httplistener -o HTTPConnector -a

mqsireportproperties BDBKRDB01 -e INT3000-INT3999 -o HTTPSConnector -a

mqsireportproperties BDBKRDB01 -e INT3000-INT3999 -o HTTPConnector -a



Data base or FTP connectivity check

mqsisetdbparms MDBKRDB06 -n FTPC_GENEVA -u erpuser -p erp

mqsicvp MDBKRDB06 -n FTPC_GENEVA



Inline image 1

kill -9 PID

rm  filepath/filename.txt

chmod 755 filename

mqsireportproperties IBNODE -c SAPConnection -o AllReportableEntityNames -r



mqsichangetrace BDBKRDB01 -u -e PSES_I3051_I3099 -f I3065_FTPC_GENEVA_STACKTRANS_EISERVICE -c 1400000 -r -l debug

mqsireadlog MDBKRDB06 -u -f -e INT3000-3999 -o /var/ibm/i3605_LOGFILE.xml

mqsiformatlog -i D:\wmb\i2208_LOGFILE.xml -o /var/ibm/i3605_LOGFILE_OUTPUT.xml

mqsichangetrace BDBKRDB01 -u -e PSES_I3051_I3099 -f I_FTPC_GENEVA_STACKTRANS_EISERVICE -c 1400000 -r -l debug


mqsireadlog MDBKRDB06 -u -f -e PSES_I3051_I3099 -o D:\Atanu\log.xml





mqsiformatlog -i D:\Atanu\log.xml -o D:\Atanu\log_output.xml




mqsireportproperties BDBKRDB01 -e PSES_I3051_I3099 -o HTTPSConnector -n port



mqsireportproperties BDBKRDB01 -e PSES_I3051_I3099 -o HTTPSConnector -a



mqsireportproperties BDBKRDB01 -e PSES_I3051_I3099 -o HTTPConnector -a
mqsireportproperties AB300D001 -e PSES_I3051_I3099 -o HTTPConnector -a
mqsichangeproperties AB300D001 -e PSES_I3051_I3099 -o HTTPConnector -n port -v 7800

mqsichangeproperties AB300D001 -b httplistener -o HTTPConnector -n port -v 7800

mqsireportproperties AB300D001 -e PSES_I3051_I3099 -o HTTPConnector -a

mqsichangeproperties AB300D001 -b httplistener -o HTTPConnector -n port -v 7800


mqsireportproperties MDBKRDB06 -o AllReportableEntityNames -r -b httpslistener

mqsireportproperties MDBKRDB06 -e PSES_I3051_I3099 -o AllMessageFlows -a

mqsilist -a -r -d2


mqsicreateconfigurableservice IB9NODE -c SAPConnection -o mySAPAdapter.outadapter
-n applicationServerHost,client -v test.sap.ibm.com,001
You can set the user name and password for an SAP adapter by using the mqsisetdbparms command.


mqsicreateconfigurableservice <Broker Name> -c FtpServer -o PROCESSMAPYFAI_SFTP -n serverName,scanDelay,transferMode,connectionType,securityIdentity -v 66.216.21.177:22,20,,BINARY,PASSIVE, PROCESSMAPYFAI


keytool -import -trustcacerts -alias MDBKRDB06_PSES -file MDBKRDB06_PSES.cer -keystore BDBKRDB01_PSES.jks

 curl -l "https://j700s013.autoexpr.com:7849/eiservices/v1/I3065_GetSTACKTRANS" -k
 keytool -list -v -keystore BDBKRDB01_PSES.jks

 tail -f /var/log/wmb.log  
 netstat -an | grep -i 7843
cp /tmp/MDBKRDB06_PSES.cer /home/eimb/.
`


  mqsicreateconfigurableservice BDBKRDB01 -c SAPConnection -o I3065_FTPC.outadapter -n applicationServerHost,client,rfcProgramID,systemNumber -v b700u041.bg.eu.jci.com,300,PSSAP,20
   mqsisetdbparms BDBKRDB01 -n I3065P.outadapter -u BWIADAPT -p Summer@01
 
 
 
 
   mqsisetdbparms BDBKRDB01 -n I3065P.outadapter -u BWIADAPT_2 -p Brqrfc1
 
   I3065_FTPC.outadapter
 
   mqsisetdbparms BDBKRDB01 -n I3065_FTPC.outadapter -u BWIADAPT_2 -p Brqrfc1
 
   mqsisetdbparms MDBKRQB06 -n FTPC_GENEVA -u erpuser -p erp

Message Broker Commands



Message Broker Commands                                                    

1 . Queue Manager Commands
* * * * * * * * * * * * * * * * * * * * * *
Create a Queue Manager
crtmqm <QUEUE_MANAGER_NAME>

Start a Queue Manager
strmqm <QUEUE_MANAGER_NAME>

Stop Queue Manager
endmqm -i <QUEUE_MANAGER_NAME>

Delete Queue Manager
dltmqm <QUEUE_MANAGER_NAME>

Define and view Queue Manager Configuration using runmqsc

Open mqsc console for Queue Manager
runmqsc <QUEUE_MANAGER_NAME> --> Press Enter

Display list of Local Queue
display QLOCAL(*)
dis QLOCAL(*)
dsp QLOCAL(*)


Display list of Remote Queue
display QREMOTE(*)

Create Local Queue Under Queue Manager
DEFINE QLOCAL(QUEUE_NAME)


Create Local Queue Under Queue Manager overriding default value e.g maxdepth
DEFINE QLOCAL(QUEUE_NAME) MAXDEPTH(100000)

Create Server Connection Channel
DEFILE CHANNEL(CHANNEL_NAME) CHLTYPE(SVRCONN) TRPTYPE(TCP)

To view the list of local queues created under a Queue Manager:
runmqsc QUEUE_MANAGER_NAME -> Press ENTER
dis qlocal(*)
end
[As an alternative to 'dis', 'display' or 'dsp' can also be used. 'end' is used to exit performing any operations on the QUEUE_MANAGER_NAME]

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
  WebSphere Message Broker Commands
* * * * * * * * * * * * * * * * * * * * * * * *
To view the Components (Broker, Configuration Manager & Queue Manager associated with the Broker) created:

mqsilist

To view the Execution Groups created under a particular Broker: (The 4-digit number displayed against each Execution Group is the Process ID of the Process DataFlowEngine.exe which corresponds to an Execution Group)

mqsilist BROKER_NAME

To view the Flows & Resources (Jars, Message Dictionaries, Message Maps etc) deployed onto a Broker's Execution Group:

mqsilist BROKER_NAME -e EXECUTION_GROUP_NAME
To view the Broker's EG Properties:

mqsireportproperties BROKER_NAME -e EXECUTION_GROUP_NAME -o ObjectName -n PropertyName

To view all the properties of a Broker's EG ('-r' indicates recursive fetch, use '-a' for non-recursive fetch):
mqsireportproperties BROKER_NAME -e EXECUTION_GROUP_NAME -o AllReportableEntityNames -r

To view all the Configurable properties of a Broker ('-r' indicates recursive fetch, use '-a' for non-recursive fetch):
mqsireportproperties BROKER_NAME -c AllTypes -o AllReportableEntityNames -r

To view the Max Heap Size set to a Broker's EG:

mqsireportproperties BROKER_NAME -e EXECUTION_GROUP_NAME -o ComIbmJVMManager -n jvmMaxHeapSize

To view the Min Heap Size set to a Broker's EG:

mqsireportproperties BROKER_NAME -e EXECUTION_GROUP_NAME -o ComIbmJVMManager -n jvmMinHeapSize

To view the Debug Port set to a Broker's EG:

mqsireportproperties BROKER_NAME -e EXECUTION_GROUP_NAME -o ComIbmJVMManager -n jvmDebugPort

To change the Broker's EG Properties:

mqsichangeproperties BROKER_NAME -e EXECUTION_GROUP_NAME -o ObjectName -n PropertyName -v ValueToBeSet

To change any of the Configurable properties of a Broker ('-r' indicates recursive fetch, use '-a' for non-recursive fetch):

mqsichangeproperties BROKER_NAME -c ConfigurablePropertyName -o ObjectName -v NewValue

To change the Max Heap Size set to a Broker's EG: [-v parameter should be a value in Bytes]

mqsichangeproperties BROKER_NAME -e EXECUTION_GROUP_NAME -o ComIbmJVMManager -n jvmMaxHeapSize -v NewValue

To change the Min Heap Size set to a Broker's EG: [-v parameter should be a value in Bytes]

mqsichangeproperties BROKER_NAME -e EXECUTION_GROUP_NAME -o ComIbmJVMManager -n jvmMinHeapSize -v NewValue

To change the Debug Port set to a Broker's EG: [-v parameter should be a 4-digit value]

mqsichangeproperties BROKER_NAME -e EXECUTION_GROUP_NAME -o ComIbmJVMManager -n jvmDebugPort -v NewValue
________________________________________________________________________

Commands for taking trace: [-u indicates 'User Trace' and -t indicates 'Service Trace']
Values of -l (Trace Level) parameter:
1. normal,
2. none,
3. debug.
Values of -m (Mode) parameter:
1. safe,
2. fast.

User Trace:

To view the user trace: (Optional -f to view the trace level of a particular message flow deployed onto an EG)

mqsireporttrace BROKER_NAME -u -e EXECUTION_GROUP_NAME -f MESSAGE_FLOW_NAME

To set the user trace: (Optional -f to view the trace level of a particular message flow deployed onto an EG)

mqsichangetrace BROKER_NAME -u -e EXECUTION_GROUP_NAME -f MESSAGE_FLOW_NAME -l TRACE_LEVEL -c SIZE_OF_TRACE_IN_KB

Service Trace:

To view the service trace: (Optional -f to view the trace level of a particular message flow deployed onto an EG)
mqsireporttrace BROKER_NAME -t -e EXECUTION_GROUP_NAME -f MESSAGE_FLOW_NAME

To set the service trace: (Optional -f to view the trace level of a particular message flow deployed onto an EG)

mqsichangetrace BROKER_NAME -t -e EXECUTION_GROUP_NAME -f MESSAGE_FLOW_NAME -l TRACE_LEVEL -c SIZE_OF_TRACE

To read the trace file: (Optional -f to view the trace level of a particular message flow deployed onto an EG)
mqsireadlog BROKER_NAME -u/-t -e EXECUTION_GROUP_NAME -f MESSAGE_FLOW_NAME -o PATH_TO_FILE_WITH_NAME_AND_EXTENSION
________________________________________________________________________
To create a BAR file:

mqsicreatebar -data PATH_TO_BAR_DIRECTORY -b BAR_FILE_NAME -p PROJECT_NAME -o NAME_OF_THE_RESOURCE_TO_BE_ADDED_WITH_EXTN
['-cleanBuild' parameter can be used to refresh the workspace projects and perform a clean build before adding]
Syntax: mqsicreatebar -data workspace -b barName [-version id] [-esql21] [-p projectName [...]] -o filePath1 [filePath2 [...]]
Command Options:
'-data workspace' workspace location (Mandatory)
'-b barName' bar file name to create or replace
'-version id' appends '_' and id to compiled names in the archive (optional)
'-esql21' compile ESQL for brokers version 2.1 (optional)
'-p projectName' specify projects containing files to link (optional, multiple projects can be specified)
'-o filePath1' workspace relative path (including the project) of deployable files to add to the broker archive. Multiple deployable files can be compiled in a single mqsicreatebar command.

To cancel all outstanding deployments:

mqsideploy -n PATH_TO_CONFIGURATION_MANAGER_FILE -c
To deploy a BAR file:
mqsideploy -n PATH_TO_CONFIGURATION_MANAGER_FILE -b BROKER_NAME -e EXECUTION_GROUP_NAME -a PATH_TO_BAR_FILE_NAME

To remove a flow or resource from the Broker's EG:

mqsideploy -n PATH_TO_CONFIGURATION_MANAGER_FILE -b BROKER_NAME -e
EXECUTION_GROUP_NAME -d FLOW_OR_RESOURCE_NAME_TO_BE_UNDEPLOYED
NOTE:
1. For all the mqsideploy commands above, a combination of -i, -p & -q parameters can be used instead of -n. -i carries the machine name, -p indicates the port on which the Queue Manager is open and -q represents the name of the Queue Manager,
2. An additional '-w' parameter can be added at the end of the command to set a Timeout Value (in seconds).
________________________________________________________________________

To reload/restart a particular Execution Group:

mqsireload BROKER_NAME -e EXECUTION_GROUP_NAME
To reload/restart all the Execution Groups of the Broker: [This command does not restart the Broker]
mqsireload BROKER_NAME
________________________________________________________________________

To stop a Broker: [Optional '-i' parameter before BROKER_NAME immediately stops the Broker, else, the Broker is stopped in Control Mode. Optional '-q' parameter after BROKER_NAME stops the Broker's Queue Manager along with the Broker]

[CONFIGURATION_MANAGER_NAME, USER_NAME_SERVER or DATABASE_INSTANCE_MANAGER can be used in place of BROKER_NAME to stop the respective Component]

mqsistop BROKER_NAME
To stop a Broker's EG:
mqsistop BROKER_NAME -e EXECUTION_GROUP_NAME
To stop a Message Flow running on a Broker's EG:
mqsistopmsgflow BROKER_NAME -e EXECUTION_GROUP_NAME -m MESSAGE_FLOW_NAME
________________________________________________________________________

To start a Broker:

[CONFIGURATION_MANAGER_NAME, USER_NAME_SERVER or DATABASE_INSTANCE_MANAGER can be used in place of BROKER_NAME to stop the respective Component]
mqsistart BROKER_NAME

To start a Broker's EG:

mqsistart BROKER_NAME -e EXECUTION_GROUP_NAME
To start a Message Flow running on a Broker's EG:
mqsistartmsgflow BROKER_NAME -e EXECUTION_GROUP_NAME -m MESSAGE_FLOW_NAME
________________________________________________________________________

To set the DSN Name to a Broker which will be used by the flows deployed onto its' EGs:

mqsisetdbparms BROKER_NAME -n DSN_NAME -u USER_ID -p PASSWORD

To reset the DSN Name to a Broker which will be used by the flows deployed onto its' EGs:

mqsisetdbparms BROKER_NAME -n DSN_NAME - -u USER_ID -p PASSWORD

To remove the DSN Name to a Broker which was used by the flows deployed onto its' EGs:

mqsisetdbparms BROKER_NAME -n DSN_NAME -d
________________________________________________________________________
To list/display/export an ACL Entry:

mqsilistaclentry CONFIGURATION_MANAGER_NAME -n .configmgr_FILE_NAME -f FILE_TO_WHICH_THE_ACL_ENTRIES_ARE_EXPORTED
To create an ACL Entry:
mqsilistaclentry CONFIGURATION_MANAGER_NAME -n .configmgr_FILE_NAME -f FILE_FROM_WHICH_THE_ACL_ENTRIES_ARE_IMPORTED
To delete an ACL Entry:
mqsideleteaclentry CONFIGURATION_MANAGER_NAME -n .configmgr_FILE_NAME -f FILE_FROM_WHICH_THE_ACL_ENTRIES_ARE_IMPORTED
________________________________________________________________________
To create a Broker:

mqsicreatebroker BROKER_NAME -i USER_ID -a PASSWORD -q BROKER_QUEUE_MANAGER_NAME

To create a Configuration Manager:

mqsicreateconfigmgr CONFIGURATION_MANAGER_NAME -i USER_ID -a PASSWORD -q BROKER_QUEUE_MANAGER_NAME

To create a User Name Server: [Optional '-r' parameter can be added to set the Refresh Interval at the end of the command with a value in seconds. Default value is 60 seconds]

mqsicreateusernameserver -i USER_ID -a PASSWORD -q BROKER_QUEUE_MANAGER_NAME
________________________________________________________________________

To delete a Broker: [Optional '-q' parameter can be added to delete the associated Queue Manager along with the Broker]
[Optional '-w' parameter can be added to delete all the files related to the Broker under the work path mentioned by '-w's value]

mqsideletebroker BROKER_NAME
To delete a Configuration Manager: [Optional '-q' parameter can be added to delete the associated Queue Manager along with the Configuration Manager]
mqsideleteconfigmgr CONFIGURATION_MANAGER_NAME

To delete a User Name Server: [Optional '-q' parameter can be added to delete the associated Queue Manager along with the User Name Server]
[Optional '-w' parameter can be added to delete all the files related to the User Name Server under the work path mentioned by '-w's value]
mqsideleteusernameserver
________________________________________________________________________

To create a Configurable Service:

mqsicreateconfigurableservice BROKER_NAME -c CONFIGURABLE_SERVICE_NAME -o ObjectName -n PropertyName -v PropertyValue

To delete a Configurable Service:

mqsideleteconfigurableservice BROKER_NAME -c CONFIGURABLE_SERVICE_NAME -o ObjectName
________________________________________________________________________

To perform the Component Verification:

mqsicvp COMPONENT_NAME
[COMPONENT_NAME can be BROKER_NAME or CONFIGURATION_MANAGER_NAME]
__________________________________________________________________________________

SSL

mqsichangeproperties PPSBKRQB01 -e INT3000_INT3099 -o HTTPSConnector -n sslProtocol -v SSLv3
mqsichangeproperties PPSBKRQB01 –e INT3000_INT3099 -o HTTPSConnector -n explicitlySetPortNumber -v 7849


mqsichangeproperties PPSBKRQB01 -e INT3000_INT3099 -o HTTPSConnector -n keystoreFile -v /home/eimb/PPSBKRQB01.jks


mqsichangeproperties PPSBKRQB01 -e INT3000_INT3099 -o HTTPSConnector -n keystoreType -v JKS


mqsichangeproperties PPSBKRQB01 -e INT3000_INT3099 -o HTTPSConnector -n keystorePass -v passw0rd



keytool -genkey -alias PPSBKRQB01 -keystore PPSBKRQB01.jks -keysize 2048 -validity 3650

keytool -export -alias PPSBKRQB01_PSES -file PPSBKRQB01_PSES.cer -keystore PPSBKRQB01_PSES.jks


mqsichangeproperties PPSBKRD01  -o BrokerRegistry  -n brokerKeystoreFile  -v /MQHA/PPSBKRD01/data/mqsi/ssl/PPSBKRD01.jks
mqsisetdbparms PPSBKRDB01  -n brokerKeystore::password  -u ignore  -p passw0rd
mqsichangeproperties PPSBKRDB01   -b httplistener   -o HTTPSConnector   -n keystoreFile   -v /MQHA/PPSBKRD01/data/mqsi/ssl/PPSBKRD01.jks
mqsichangeproperties PPSBKRDB01   -b httplistener   -o HTTPSConnector   -n keystorePass   -v passw0rd
mqsichangeproperties PPSBKRDB01 –e INT3000_INT3099 -o HTTPSConnector -n explicitlySetPortNumber -v 7849

Distributed Computing: A Guide to Comparing Data Between Hive Tables Using Spark

In big data, efficient data comparison is essential for ensuring data integrity and validating data migrations. Apache Spark, with its in-me...