KB‎ > ‎

SRE commands

Generic Commands
List the componentsstccmd -rh host -rs Schema  -cb host_cb -un Administrator -up STC -cmd "list" >> NewProdList.txt

Registry and Control Broker commands
Flush the registry - stcregutil.exe -rh host -rs schema -un user -up passwd -sf
Stop the registry - stcregutil.exe -rh host -rs schema -un user -up passwd -ss
 
stciqutils (standard stc queues)- usage
Delete messages from standard queue - stciqutil -rh host -rs MySchema -un Administrator -up STC -iq iqname -event etname -pub colname  -mark DELETED -mi 1-12 -ma 00000-00000 -dt 07272010:12:12:12:111-07292010:06:06:06:006
Dump messages from standard queue to a directory - stciqutil -rh host -rs MySchema -un Administrator -up STC -iq iqname  -event etname  -pub colname  -qd -mm -od iqdump
Get the keys for messages from standard queue - stciqutil -rh host -rs MySchema -un Administrator -up STC -iq iqname   -event etname   -pub colname   -keys
Get message counts from standard queue - stciqutil.exe -rh host -rs schema -un Administrator -up STC -iq iqname -event etname -pub colpubName  -cnt
Get Live (active) message count from standard queue - stciqutil.exe -rh host -rs MySchema -un Administrator -up STC -iq iqname -event etname -pub colpubname -sub colsubname -cnt -live
 


Deleting Schema in SeeBeyond

Summary:
I need to delete certain schemas from my registry. Can anyone run me through the deletion steps?

Full Article:
Disclaimer: Contents are not reviewed for correctness and are not endorsed or recommended by ITtoolbox or any vendor. Popular Q&A contents include summarized information from SeeBeyond-L discussion unless otherwise noted.

1. Adapted from response by Mahesh on Thursday, July 24, 2003

I am not aware of any automatic method, but here is the manual one.

1. Make a list of all the schemas you wish to delete.

2. For each of these schemas list all the components.

3. For each component -
a. Double Click the E*way component and note the directory in which you are storing the configuration file (take special care of the exact spelling, as there may be similar ones with different spellings that were created and maintained for naming conventions, and if you delete the wrong one, you might have trouble finding and pinpointing the exact location of problem).
b. Go to E*way Connections, and find the directory location where you are storing the config file and note them.
c. Go to each collaboration rule, find where you store them and note the location and file names (i.e. respective .class,.ctl,.java.xpr,.xts files of each collab rule file).
d. Goto each of the event types, find where you are storing the etd's, decide if you want to delete the message etd's too, then only add those etd's to your list.

4. After doing all these excercises,
a. On your client side, go to c:\eGate\client, you will find all of these directories, go to each of them and delete them.
b. On your main server go to C:\eGate\client\ and do the same.
c. On your main server go to C:\eGate\Server\registry abd find the .rdb file of same schema name as the one you wanted to delete. Delete it.
d. Also, in directory c:\eGate\Server\registry\repository you will find the directory of same names as that of your schema. Deleting it will delete all the subdirectories (i.e. runtime , sandbox, and userlocks) for that schema.

2. Adapted from response by Matt on Thursday, July 24, 2003

One note of caution: Make sure the Registry is down before you delete the .rdb and Schema folder.

3. Adapted from response by Vijay on Thursday, July 24, 2003

I don't think you need to be worried about the client part of it (whenever a schema runs, it always brings files from server folder if there is a change).

If your are in Unix, cd to server/registry folder, rm "sch".rdb then cd to server/registry/repository and rm -rf "sch", where "sch" is the name of the schema to be wiped out.

Don't forget to bounce server once.

Creating seconf CB/PH.

stcinstd is used to instantiate the PH but it works only if the second participating host is on a separate physical host.

 

Here is the little work around

 

Step-1:
=======
From command prompt run the following script to get the .exp file (instead of a full schema export)
stcregutil.exe -rh host -rs schema -un user -up pwd -e nup.exp

 

Step-2
======
Edit the nup.exp (in any text editor) to add a new CB entry in the !REGISTRY_HOST section. Delete all other entries in the nup.exp file. Once modified the .exp file would look something like this

 

##############################################################################
#
#    E*Gate Schema:    Schema
#    Registry Name:    host
#    Export File:      nup.exp
#    Exported:         05/06/xxxx - 09:58a
#    Client Version:   5.0.5.7718
#    Server Version:   5.0.5.7718
#    DB Version:       0004.0002
#    Copyright:        (C) SeeBeyond Technology Corporation. 1996-2004
#
##############################################################################
#
##----------------------------------------------------------------------------
#
#    Table:
#
!REGISTRY_HOST
#
##----------------------------------------------------------------------------
#    fields: LN, fActive, szHostName, szDomainName, eNetworkProtocol, dwOSType
##----------------------------------------------------------------------------
ph1,TRUE,host,,NETPROTO_TCPIP,0
ph2,TRUE,host,,NETPROTO_TCPIP,0

 

Step-3
====
Import the nup.exp (that has only the modified !REGISTY_HOST section using

stcregutil.exe -rh host-rs schema -un user -up pwd -i nup.exp

Restart the edesigner to see the new active participating host and you can add a new CB to that PH.