1 / 260

DBMaintPlus

DBMaintPlus. August 23, 2012. Disclaimer

gerry
Download Presentation

DBMaintPlus

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DBMaintPlus August 23, 2012

  2. Disclaimer The DBMaintPlus Utility is designed for use by staff familiar with RB-ERP and the SQL database versions of RB-ERP. Use of this program and the procedures included in this document are at the risk of the user. WorkWise is not responsible for misapplication or misinterpretation of the procedures included in this document. DBMaintPlus and the procedures contained require that you have made sufficient backups and have a verified restore capability should issues arise. The end user of this utility and these procedures is responsible for such backups and verified restore capability. This document contains procedures which will modify both the RB-ERP SQL Database and associated ISAM “cache” files on the RB-ERP Application Server. Care to insure data integrity is of the utmost priority in the use of this document. DBMaintPlusSQL Database Maintenance Utility for RB-ERP Version V9.3 and above

  3. Recommendations • It is STRONGLY recommended that the use of this tool be done off-hours, with no users on the system. • These procedures should only be done AFTER SUFFICIENT BACKUPS are made of the current RB-ERP SQL database and ISAM files. • Multi-RB-ERP Environments - Caution !! • Be VERY careful if multiple RB-ERP environments are on your servers. You must ensure you are referencing the correct environment when following any of the procedures in this document. • Requirements for usage of this document: • RB-ERP V9.3 or above • DBMaintPlus.exe dated 8/3/2012 or better DBMaintPlusSQL Database Maintenance Utility for RB-ERP Version V9.3 and above

  4. DBMaintPlus Documentation • Location on WW network:

  5. DBMaintPlus Documentation • Location on WW network:

  6. DBMaintPlus on RB-ERP Server

  7. DBMaintPlus on SQL Server

  8. DBMaintPlus Learn by Examples #1 Copy Existing RB-ERP Company (Schema) to New RB-ERP Company (Schema)#2 Copy Existing RB-ERP Company (Schema) to Existing RB-ERP Company (Schema)#3 Create New Company (Schema) ‘abc’#4 Delete an Existing RB-ERP Company/Schema#5 Refresh Test Environment W94 Data from Live Environment V94 Data #6 Copy selected tables from one DB to another

  9. DBMaintPlus Exercise #1 • Copy Existing RB-ERP Company (Schema) to New RB-ERP Company (Schema) • Make a copy of company 'tst' to non-existing 'new' • Steps starting on Page 8 • Copy existing ISAM files from 'tst' to 'new' • Edit the EMS_REGISTRY.NEW file • Create the logical RB-ERP company 'new' • Verify “connection string”  NEW TERM • Create xfODBC connection file for 'new'

  10. DBMaintPlus Exercise #1 • On SQL Server - Create schema for ‘new’ • RB-ERP Server – DCM to Obtain DCM Version • On SQL Server – Verify Linked Server Working • RB-ERP Server – DCM Tool to Update Schema • RB-ERP Server – DBMaintPlus – Copy Schema • RB-ERP Server – Delete/Create Cache Files • RB-ERP Server – Verify Sync’ed Cache Files • Additional tasks • Background Scheduler and DC Services and process configurations as required

  11. DBMaintPlus Exercise #1 • Copy existing ISAM files from 'tst' to 'new' Note – this will copy cache files etc from the DSQ folder! Bad news – it takes more time ! Good news – it verifies that there is enough space for the copies! The “ED” application files are the ONLY ones that need to be copied. If you want to only copy “ED” files, use the command: copy_tcmdata X:\tcm\W94_DATA0\ED tst new

  12. DBMaintPlus Exercise #1 • Copy existing ISAM files from 'tst' to 'new'

  13. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file

  14. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file

  15. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file

  16. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file

  17. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file Note – I always use: ‘spaceCMPspace’ NOTE – Do the above replace using the “Match Case” selection and do it twice: TST  NEW and then tst new

  18. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file

  19. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file

  20. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file

  21. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file

  22. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file

  23. DBMaintPlus Exercise #1 • Edit the EMS_REGISTRY.NEW file CTRL_Z to finish !

  24. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new'

  25. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance

  26. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance Select Add Company Code

  27. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance Select Add Company Code Select a blank entry (6) Enter ‘new’

  28. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance Select Add Company Code Select a blank entry (6) Enter ‘new’ 99% use (C)opy

  29. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance Select Add Company Code Select a blank entry (6) Enter ‘new’ 99% use (C)opy Warning Message - YES

  30. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance Select Add Company Code Select a blank entry (6) Enter ‘new’ 99% use (C)opy Warning Message – YES Company code to copy

  31. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance Select Add Company Code Select a blank entry (6) Enter ‘new’ 99% use (C)opy Warning Message – YES Company code to copy

  32. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance Select Change Company Name

  33. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance Select Change Company Name Enter ‘new’

  34. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance Select Change Company Name Enter ‘new’ Enter new company name

  35. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Company Maintenance Select Change Company Name Enter ‘new’ Enter new company name

  36. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Password/Device Maint

  37. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Password/Device Maint Add a new password

  38. DBMaintPlus Exercise #1 • Create the logical RB-ERP company 'new' Using Navigator Password/Device Maint Add a new password SUPERPASS | new ‘M’ for all files ‘R’ for all files

  39. DBMaintPlus Exercise #1 • Verify “connection string”  NEW TERM Using Navigator Company Maintenance Connection String Maint

  40. DBMaintPlus Exercise #1 • Verify “connection string”  NEW TERM Using Navigator Company Maintenance Connection String Maint Enter new company ‘new’

  41. DBMaintPlus Exercise #1 • Verify “connection string”  NEW TERM Using Navigator Company Maintenance Connection String Maint Enter new company ‘new’ Hitting enter on field to chg will verify the string

  42. DBMaintPlus Exercise #1 • Verify “connection string”  NEW TERM Using Navigator Company Maintenance Connection String Maint Enter new company ‘new’ Hitting enter on field to chg will verify the string

  43. DBMaintPlus Exercise #1 • Verify “connection string”  NEW TERM SQL DB USERNAME | PW

  44. DBMaintPlus Exercise #1 • Verify “connection string”  NEW TERM SQL DB USERNAME | PW

  45. DBMaintPlus Exercise #1 • Verify “connection string”  NEW TERM SQL SERVER DSN NAME

  46. DBMaintPlus Exercise #1 • Verify “connection string”  NEW TERM SQL SERVER NAME

  47. DBMaintPlus Exercise #1 • Verify “connection string”  NEW TERM SQL DB NAME

  48. DBMaintPlus Exercise #1 • Create xfODBC connection file for 'new' X:\var\tcm\connect Copy ‘tst’ con file to ‘new’ new_W94.con

  49. DBMaintPlus Exercise #1 • Create xfODBC connection file for 'new' Edit ‘new’ con file

  50. DBMaintPlus Exercise #1 • Create xfODBC connection file for 'new' Replace ‘.tst’ with ‘.new‘

More Related