| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Deleting Client Channel entry from AMQCLCHL.TAB |
« View previous topic :: View next topic » |
| Author |
Message
|
| LouML |
 Posted: Thu May 22, 2008 8:55 am Post subject: Deleting Client Channel entry from AMQCLCHL.TAB |
 |
|
Partisan
Joined: 10 Nov 2005
Posts: 305
Location: Jersey City, NJ / Bethpage, NY
|
We're running MQ 6.0.2.3 on a Sun Solaris box.
We need to change the hostname on a client channel. However, there are two entries in the AMQCLCHL.TAB file for this particular client channel name. I imagine that at some point in the past, the previous admin defined the same channel with a new conname, but did not use the 'replace' option', thus leaving two entries. I expect that the 1st entry is the one being used by clients.
First I tried to do a 'define channel ... replace', but the last entry is the one that gets updated.
Then I tried to to do a 'delete channel' command. It looks like it worked successfully and the AMQCLCHL.TAB file date gets updated. However, when I look in the file, the entries are still there.
Any ideas?
| Code: |
bash-2.05$ ls -la
total 324
drwxrwsr-x 7 mqm mqm 512 May 22 12:15 .
drwxrwsr-x 25 mqm mqm 1024 May 14 15:12 ..
-rw-r----- 1 mqm mqm 139314 May 22 12:32 AMQCLCHL.TAB
-rw-rw---- 1 mqm mqm 2008 May 22 12:11 AMQCLCHL.TAB.save
-rw-rw---- 1 mqm mqm 8 Jun 25 2007 AMQRSYNA.DAT
drwxrwsr-x 2 mqm mqm 512 Jun 25 2007 esem
drwxrwsr-x 2 mqm mqm 512 Jun 25 2007 isem
drwxrwsr-x 2 mqm mqm 512 Jun 25 2007 msem
drwxrwsr-x 2 mqm mqm 512 May 14 15:12 shmem
drwxrwsr-x 2 mqm mqm 512 Jun 25 2007 spipe
bash-2.05$ strings AMQCLCHL.TAB | grep -i QAMSG1P
CH.QAMSG1P.CLIENT
QM.QAMSG1P.01 123.123.21.81(1414) 2
CH.QAMSG1P.CLIENT
QM.QAMSG1P.01 qamsg1p.us.xyzco.com 2
qamsg1p.us.xyzco.com(1414)
bash-2.05$ echo "delete chl('CH.QAMSG1P.CLIENT') chltable(clnttbl)" | runmqsc QM.QWORKS2.01
5724-H72 (C) Copyright IBM Corp. 1994, 2005. ALL RIGHTS RESERVED.
Starting MQSC for queue manager QM.QWORKS2.01.
1 : delete chl('CH.QAMSG1P.CLIENT') chltable(clnttbl)
AMQ8015: WebSphere MQ channel deleted.
One MQSC command read.
No commands have a syntax error.
All valid MQSC commands were processed.
bash-2.05$ ls -la
total 324
drwxrwsr-x 7 mqm mqm 512 May 22 12:15 .
drwxrwsr-x 25 mqm mqm 1024 May 14 15:12 ..
-rw-r----- 1 mqm mqm 139314 May 22 12:38 AMQCLCHL.TAB
-rw-rw---- 1 mqm mqm 2008 May 22 12:11 AMQCLCHL.TAB.save
-rw-rw---- 1 mqm mqm 8 Jun 25 2007 AMQRSYNA.DAT
drwxrwsr-x 2 mqm mqm 512 Jun 25 2007 esem
drwxrwsr-x 2 mqm mqm 512 Jun 25 2007 isem
drwxrwsr-x 2 mqm mqm 512 Jun 25 2007 msem
drwxrwsr-x 2 mqm mqm 512 May 14 15:12 shmem
drwxrwsr-x 2 mqm mqm 512 Jun 25 2007 spipe
bash-2.05$ strings AMQCLCHL.TAB | grep -i QAMSG1P
CH.QAMSG1P.CLIENT
QM.QAMSG1P.01 123.123.21.81(1414) 2
CH.QAMSG1P.CLIENT
QM.QAMSG1P.01 qamsg1p.us.xyzco.com 2
qamsg1p.us.xyzco.com(1414)
bash-2.05$ |
_________________
Yeah, well, you know, that's just, like, your opinion, man. - The Dude |
|
| Back to top |
|
 |
| KramJ |
| Posted: Thu May 22, 2008 9:16 am Post subject: |
|
|
Voyager
Joined: 09 Jan 2006
Posts: 80
Location: Atlanta
|
Try:
delete chl(channel_name) chltable(clnttbl)
Then:
def chl(channel_name) chltype(clntconn) |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu May 22, 2008 9:41 am Post subject: Re: Deleting Client Channel entry from AMQCLCHL.TAB |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| LouML wrote: |
Then I tried to to do a 'delete channel' command. It looks like it worked successfully and the AMQCLCHL.TAB file date gets updated. However, when I look in the file, the entries are still there.
|
If you think it's worked, it probably did. IIRC old entries are tagged as deleted rather than actually removed.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| LouML |
| Posted: Thu May 22, 2008 9:45 am Post subject: |
|
|
Partisan
Joined: 10 Nov 2005
Posts: 305
Location: Jersey City, NJ / Bethpage, NY
|
Well, what I wound up doing was:
1 - Save a copy of the Queue Manager configuration using saveqmgr.
2 - Edit the file to remove all DEFINES except Client Channels.
3 - Create a test Queue Manager.
4 - Load the newly created config file to this test Queue Manager.
5 - Rename the current AMQCLCHL.TAB file to save it.
6 - Copy the newly created AMQCLCHL.TAB file to the current QM's directory
_________________
Yeah, well, you know, that's just, like, your opinion, man. - The Dude |
|
| Back to top |
|
|
| Vitor |
| Posted: Thu May 22, 2008 9:49 am Post subject: |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| LouML wrote: |
3 - Create a test Queue Manager.
4 - Load the newly created config file to this test Queue Manager.
5 - Rename the current AMQCLCHL.TAB file to save it.
6 - Copy the newly created AMQCLCHL.TAB file to the current QM's directory |
It's perfectly valid. I know some people who have a single queue manager on which they generate all the TAB files for their organisation.
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| gbaddeley |
| Posted: Thu May 22, 2008 5:21 pm Post subject: Re: Deleting Client Channel entry from AMQCLCHL.TAB |
|
|
Jedi Knight
Joined: 25 Mar 2003
Posts: 2538
Location: Melbourne, Australia
|
| Vitor wrote: |
| ... IIRC old entries are tagged as deleted rather than actually removed. |
Correct. An alternative method of managing CCDT files is to use SupportPac MO72. The 'strings' command doesn't tell you much.
_________________
Glenn |
|
| 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
|
|
|
|
