Oninit cdi / Archive
Talk to an expert →

regarding sysmaster

Posted in 2003

Topics: General Discussion

Nagarjuna Kurra — — source: IIUG Forums & Mailing Lists

hi ra , can we remove the entries of particular datasbase, in all the sysmaster database, by doing so all the databases.are droped. with regards Nagarjuna.K

↪ replying to Nagarjuna Kurra
John Magie — — source: IIUG Forums & Mailing Lists

Nagarjuna, No, you can not remove a database by removiing entries in the sysmaster database. There are tables which can not be deleted from that stores information about the database. If you are not able to drop the database with normal sql statements then Tech Support will need to dial into the host where the instance is and drop it for you. Thanks, Mike John Michael Magie Advanced Support Engineer IBM Data Management Solutions, Software Group Tel : 1-800-274-8184 Fax : 913-599-7185 internet : jmagie@us.ibm.com http://www-4.ibm.com/software/data/informix "Nagarjuna K...." <nagarjuna.kurra@guja To: ids@iiug.org ratgas.com> cc: Sent by: Subject: regarding sysmaster [655] forum.subscriber@iiug .org 03/12/2003 01:42 AM hi ra , can we remove the entries of particular datasbase, in all the sysmaster database, by doing so all the databases.are droped. with regards Nagarjuna.K

↪ replying to Nagarjuna Kurra
Jonathan Leffler — — source: IIUG Forums & Mailing Lists

No - you can't mess with sysmaster like that and expect to have a working system afterwards. -- Jonathan Leffler (jleffler@us.ibm.com) STSM, Informix Database Engineering, IBM Data Management Solutions 4100 Bohannon Drive, Menlo Park, CA 94025 Tel: +1 650-926-6921 Tie-Line: 630-6921 "I don't suffer from insanity; I enjoy every minute of it!" |---------+--------------------------------> | | "Nagarjuna K...." | | | <nagarjuna.kurra@guja| | | ratgas.com> | | | Sent by: | | | forum.subscriber@iiug| | | .org | | | | | | | | | 03/11/2003 11:42 PM | | | | |---------+--------------------------------> >------------------------------------------------------------------------------- --------------------------------------------------------------| | | | To: ids@iiug.org | | cc: | | Subject: regarding sysmaster [655] | | | >------------------------------------------------------------------------------- --------------------------------------------------------------| hi ra , can we remove the entries of particular datasbase, in all the sysmaster database, by doing so all the databases.are droped. with regards Nagarjuna.K