(MIGWEBQRY) Command
Contents
1. gt XDIF SAME xDIF Phase of migration gt XRESTORE xSAVE xRESTORE x SAVRST Clear existing migration logs xNO_ xYES xNO 5 2 6 If parameter Clear existing migration logs is specified as YES existing migration logs in qibm userdata qwebqry base80 migration_import before the migration will be removed Old history from prior migrations will be cleaned up Migrate DB2 Web Query MIGWEBQRY Type choices press Enter gt XDIFSYS KSAMESYS DIFSYS Web Query level lt w amp we DIF xSAME DIF Phase of migration gt XRESTORE xSAVE xRESTORE x SAVRST gt YES xYES NO Type of migration Clear existing migration logs 5 2 7 Press F16 to confirm Confirm DB2 Web Query Migration ARNING ou have requested to perform a DB2 Web Query migration This process will clear the current DB2 Web Query repository on this system and replace it with content from the migrated system Please make sure you have saved any critical repository content before proceeding confirm and continue with the migration request af laL N a ool am an i a migration request 5 2 8 Contents in Web Query QU2 are restored on the target system and migrated to WQX Web Query will be started 5 2 9 Optionally enter command MIGWEBQRY TYPE DIFSYS LEVEL DIF PHASE CLEANUP It will delete temporary files and directories created by the migration Migrate DB2 Web Query MIGWEBQRY T2. DIFSYS Phase of migration i gt KXCLEANUP XSAVE X RESTORE X SAVRST 10 DB2 Web Query MIGWEBQRY Command 5 2 Different System Migration Follow these steps if you are migrating from QU2 on one system to WQX on another system On the source system 5 2 1 Make sure that QU2 is installed Make sure that Web Query servers are ended by using the WRKWEBQRY command 5 2 2 Enter command QWEBQRY77 MIGWEBQRY TYPE DIFSYS PHASE SAVE or QWEBQRY76 MIGWEBQRY TYPE DIFSYS PHASE SAVE or QWEBQRY MIGWEBQRY TYPE DIFSYS LEVEL DIF PHASE SAVE Migrate DB2 Web Query MIGWEBQORY xDIFSYS 5 2 3 After the SAVE operation save file QGPL QWQMIGLIB is created on the source system FTP the save file QGPL QWQMIGLIB to the target system The steps are e On the target system create a save file by the command CRTSAVF QGPL QWQMIGLIB e On the source system issue these commands one by one FTP target_system_address Input username password namefmt O bin put qgpl qwamiglib qgpl qwaqmiglib bye press F3 to quit On the target system 5 2 4 Make sure that WQX version 2 1 0 is installed Make sure Web Query servers are ended using the WRKWEBQRY command 5 2 5 Enter command QWEBQRY MIGWEBQRY TYPE DIFSYS LEVEL DIF PHASE RESTORE 11 DB2 Web Query MIGWEBQRY Command Migrate Web Query MIGWEBQRY Type choices press Enter Type of migration gt XxXDIFSYS XSAMESYS xDIFSYS Web Query level
3. test partition You can use Save and Restore commands to copy the metadata files and repository library from one system to the other but it is recommended to instead use MIGWEBQRY because it additionally handles user licenses and authorization lists To migrate 2 1 0 from one system to another follow these steps 4 1 On the source system 4 1 1 Make sure that WQX version 2 1 0 is installed Make sure the Web Query servers are ended using the Work Web Query WRKWEBQRY command 4 1 2 Enter command QWEBQRY MIGWEBQRY TYPE DIFSYS LEVEL SAME PHASE SAVE Migrate DB2 Web Query MIGWEBQRY xDIFSYS DB2 Web Query MIGWEBQRY Command 4 1 3 Contents in Web Query WQX 2 1 0 are saved on the source system Save file QGPL QWQMIGWAx is created FTP the save file QGPL AWQMIGWAQx to the target system The steps are e On the target system create a save file by the command CRTSAVF QGPL QWQMIGWQX e On the source system issue these commands one by one FTP target_system_address Input username password namefmt O bin put qgpl qwqmigwax qgpl qwqmigwaqx bye press F3 to quit 4 2 On the target system 4 2 1 Make sure that WQX version 2 1 0 is installed Make sure the Web Query servers are ended using the WRKWEBQRY command 4 2 2 Enter command QWEBQRY MIGWEBQRY TYPE DIFSYS LEVEL SAME PHASE RESTORE Migrate DB2 Web Query MIGWEBQRY xDIFSYS 4 2 3 Press F16 to confirm DB2 Web Query MIGWEBQRY Command Confirm DB2 Web
4. DB2 Web Query MIGWEBQRY Command IBM DB2 Web Query 2 1 0 Migrate Web Query MIGWEBQRY Command User Manual DB2 Web Query MIGWEBQRY Command Table of Contents Migrate Web Query MIG WEBORY C Omman acces caxnanes sewasorssarascranernuansiacnueus reneeaniawseneaiarauaueseuuevavenneansiawces i ETO O secede E hc tnce ct ete ects vest abe estes ced ae een pack aliaeemeenanacneedeneenbenaaacneetedecnbeceaee 3 Zee eb I CQUIT IMCS xc acnameecncicaoaGecsaseudantenaed sake moancacanaGnsncnancachamach nce oedautevesGesnsmeseacheoncmnoicaoasectasecsaniamnenacheaesamoncasce 3 Oe OMEN E E E E E E E E E E 4 DW Web Oue 2 Lee E E E N E 4 ea LO e n nea o age S al SA A A E AAA E AA EE A E E EA ES 6 4 Migrating WQX from One System to Another ssneeneeeesssssssssssesoeeeerrressssssssssssseceeererressssssssssssseeerrrreesesssss 7 O O O a y ee E E A E 7 Bd nhe Taat SYS Ue Ml ra EE E ER NE 8 4 3 Cleanup on the source ANG Tar CES YSICINS wiczciscnzescaccuncsesdseaosandsuactaddcuacieaesenetes duwansusddenesaddcuneseadsuacineddawasdabes 9 Dora CUZ UG VW I A E E E 9 SAE E E A O EA A AEA A 9 32 Diktor nt systemi miota Oe a a E E E E E 11 EE EC EIN AAE E A AE E A AE E AAE E A T A A E E E E E A due 13 A E e E E E E E E E E E E E E E E E E E 13 DB2 Web Query MIGWEBQRY Command 1 Introduction This document provides instructions for the Migrate Web Query MIGWEBQRY command The MIGWEBQRY command supports Different level migrations IBM DB2 Web Query mi
5. ESTORE for parameter Phase of migration press Enter Migrate DB2 Web Query MIGWEBQRY Type choices press Enter Type of migration i ee ee Ce Om Co xDIFSYS SAMESYS DIFSYS Web Query level aca Se TB de a A xDIF xSAME xDIF Phase of migration a a a a xRESTORE SAVE RESTORE xSAVRST Clear existing migration logs xNO YES NO The parameter Clear existing migration logs here is the same as that in section 3 1 3 3 2 Web Query 1 1 2 or 1 1 1 Command Web Query 1 1 2 QWEBQRY77 MIGWEBQRY 6 DB2 Web Query MIGWEBQRY Command Web Query 1 1 1 QWEBQRY76 MIGWEBQRY 3 2 1 Enter the library qualified MIGWEBQRY command Migrate DB2 Web Query MIGWEBORY The parameters Type of migration and Phase of migration are the same as the command for WQX 2 1 0 Since 1 1 2 PTF all save file for QU2 1 1 1 is applied on the system with QU2 version 1 1 2 or 1 1 1 only for different level migration input value DIFSYS for Type of migration and SAVE for Phase of migration 4 Migrating WQX from One System to Another Sometimes it is necessary to migrate metadata reports and schedules from one Web Query 2 1 0 installation to another One reason you might do that is if you are replacing an old machine with new hardware Other reasons you might do it is if you are setting up a second system for disaster recovery DR purposes or updating a production partition from a development
6. MESYS xDIFSYS Phase of migration xSAVRST xSAVE xRESTORE SAVRST Clear existing migration logs xNO xYES xNO 5 1 3 If parameter Clear existing migration logs is specified as YES existing migration logs in qibm userdata qwebqry base80 migration_import before the migration will be removed Old history from prior migrations will be cleaned up Migrate DB2 Web Query MIGWEBORY Type choices o7 at t te od oe 7 ae Type of migration bo ee ee o o a KSAMESYS KSAMESYS DIFSYS Phase of migration 3 KSAVRST KSAVE X RESTORE XSAVRST Clear existing migration logs KYES KYES NO 5 1 4 Press F16 to confirm Confirm DB2 Web Query Migration ARNING ou have requested to perform a DB2 Web Query migration This process will clear the current DB2 Web Query repository on this system and replace it with content from the migrated system Please make sure you have saved any critical repository content before proceeding ress F16 to confirm and continue with the migration request d a 1 1 0 oe Va Wo u r a OA O ae oo a the migration request 5 1 5 Contents in Web Query QU2 are migrated to WQX Web Query will be started 5 1 6 Optionally enter command MIGWEBQRY TYPE SAMESYS PHASE CLEANUP It will delete temporary files and directories created during the migration Migrate DB2 Web Query MIGWEBORY Type choices press Enter Type of migration owe Ce a oa ae D2 XSAMESYS KXSAMESYS
7. QRY SAMNESYS The parameter Phase of migration indicates which operation will be executed in the migration SAVE Save operation Not allowed for migration on the same system RESTORE Restore operation Not allowed for migration on the same system 4 DB2 Web Query MIGWEBQRY Command CLEANUP clean up temporary files and directories created during migration SAVRST save and restore operation 3 1 3 If input SAVRST for parameter Phase of migration press Enter Migrate DB Web Query MIGWEBQRY SANESYS The parameter Clear existing migration logs indicates whether existing migration logs in directory qibm userdata qwebary base80 migration_import should be cleared before the migration NO existing migration logs will not be removed before the migration Default value VYES existing migration logs will be removed before the migration The old history from prior migrations will be cleaned up 3 1 4 Input DIFSYS for parameter Type of migration Press Enter Migrate DB2 Web Query MIGWEBQRY DIFSYS The parameter Web Query level means which levels of Web Query edition are migrated from to SAME Web Query WQX is migrated to WQX same level For the interface after SAME is input please go to section 3 1 5 DIF Web Query is migrated from QU2 to WQX different level For the interface after SAME is input please go to sectio
8. Query Migration 4 2 4 Contents in Web Query 2 1 0 are restored on the target system Web Query will be started 4 3 Cleanup on the source and target systems Optionally run the MIGWEBQRY command again for phase CLEANUP It will delete save files and temporary files created during migration including QGPL AWQMIGWQx Migrate DB2 Web Query MIGWEBORY KDIFSYS 5 Migrating QU2 to WQX This section covers the scenario where you are upgrading Web Query from version 1 to version 2 and you need to migrate reports from the QU2 product to the WQX product A migration occurs automatically when WQX is initially installed and started If you want to re migrate use the MIGWEBQRY command One reason you might want to re migrate is if developers add or modify QU2 reports between the time that you install WQX and that you are ready to move it into production and you want to pick up their changes Another reason you might want to use MIGWEBQRY is if you are migrating from QU2 on an old machine to WQX on a new machine 5 1 Same system migration Follow these steps if you are migrating from QU2 on one system to WQX on the same system 9 DB2 Web Query MIGWEBQRY Command 5 1 1 Make sure that QU2 and WQX are both installed and inactive on the system 5 1 2 Enter command QWEBQRY MIGWEBQRY TYPE SAMESYS PHASE SAVRST Migrate DB2 Web Query MIGWEBQRY Type choices press Enter Type of migration i s sx xSAMESYS xSA
9. gration from QU2 version 1 1 1 or 1 1 2 to WQX version 2 1 0 on either the same system or different systems These things in Web Query will be migrated Licensed users Synonyms Reports Schedules Distribution lists Same level migrations IBM DB2 Web Query migration from WQX version 2 1 0 on the source system to WQX version 2 1 0 on the target another system These things in Web Query will be migrated Licensed users and roles groups Authorization lists Synonyms Reports Schedules Distribution lists The MIGWEBQRY command allows for re migration of content It can be used repeatedly if you want to start over with your migration All development work in 2 1 0 on the target system will be lost during this process If there are any Web Query 2 1 0 top level folders metadata or reports that should be preserved during the migration export them using Change Management and save them so that you can import them when the migration is complete The user performing these steps must have ALLOBJ authority 2 PTF Requirements The MIGWEBQRY command was introduced into Web Query by means of PTF Below are the required PTFS for this support 2 1 0 WQX S153858 PTF S153858 applies to product 5733WQX Itis included in Web Query 2 1 0 group PTF level 9 and later It is required DB2 Web Query MIGWEBQRY Command 1 1 2 QU2 S153266 S153266 is an individual PTF for product 5733QU2 that was released after Web Q
10. n 3 1 7 3 1 5 Input SAME for parameter Web Query level Press Enter Migrate DB2 Web Query MIGWEBORY DIFSYS The parameter Product means which edition of Web Query is migrated Currently 5733 WQX to 5733WQxX migration is supported The default value is S733WQX 3 1 6 The parameter Phase of migration indicates which operation will be executed in the migration DB2 Web Query MIGWEBQRY Command Specify Yalue for Parameter PHASE Type choice press Enter Phase of migration SAVE RES TORE KSAYVRST CLEANUP SAVE save operation on the source system RESTORE restore operation on the target system CLEANUP clean up save files created during migration SAVRST save and restore operation Not allowed for same level migration 3 1 7 Input DIF for parameter Web Query level Press Enter Migrate DB2 Web Query MIGWEBQRY Type choices press Enter Type of migration gt XxDIFSYS XSAMESYS DIFSYS Web Query level gt XDIF SAME DIF Phase of migration xSAVE RESTORE x SAVRST The parameter Phase of migration indicates which operation will be executed in the migration SAVE Save operation RESTORE Restore operation CLEANUP Clean up temporary files and directories created during migration SAVRST Save and restore operation Not allowed for migration on the different systems 3 1 8 If input R
11. uery 1 1 2 group PTF level9 This PTF is required if you are migrating from QU2 on one system to WQX on another system The PTF is not required if you are migrating from QU2 to WQX and both products are installed on the same system Notice 1 There is no PTF for QU2 1 1 1 If you are migrating from QU2 1 1 1 on one system to WQX on another system contact qu2 us ibm com to receive a save file with the MIGWEBQRY command 2 When migrating WQX from one system to another the Web Query fix level that is the group PTF level and individual PTFs applied on the source and target systems should be the same Otherwise the migration will fail 3 Command Interface 3 1 Web Query 2 1 0 Command QWEBQRY MIGWEBQRY 3 1 1 Issue QWEBQRY MIGWEBQRY Press Enter Migrate DB2 Web Query MIGWEBORY The parameter Type of migration indicates whether the migration will perform on the same system or different systems The parameter values are SAMESYS Web Query QU2 will be migrated to WQX on the same system For the interface after SAMESYS is input please go to section 3 1 2 DIFSYS Web Query QU2 on one system will be migrated to WQX on a different system Or Web Query WQX on one system will be migrated to WQX on a different system For the interface after DIFSYS is input please go to section 3 1 4 3 1 2 Input SAMESYS for parameter Type of migration Press Enter Migrate DB Web Query MIGWEBO
12. ype choices press Enter Type of migration gt XDIFSYS XSAMESYS xDIFSYS Web Query level gt XDIF SAME xDIF Phase of migration CLEANUP xSAVE RESTORE xSAVRST 12 DB2 Web Query MIGWEBQRY Command 6 Restrictions 1 Migration from QU2 1 1 0 is not supported If you are upgrading to WQX from QU2 1 1 0 contact gu2 us ibm com for assistance 2 When migrating from QU2 to WQX on another system QU2 must not exist on the target system 3 For different level migration the user licenses are migrated but the user roles such as Developer or Scheduler are not You must log into the 2 1 0 Security Center as QWQADMIN and manually add the licensed users to the appropriate folder groups after migration to assign their roles and permissions 4 For each user license migrated from the source system to the target system the user profile must preexist on the target system If not a message will be sent and the operation will stop 7 Further Assistance IBM Lab Services offers a QU2 to WQX migration service that can assist you with migration The service addresses considerations of moving to InfoAssist from the no longer available web based authoring tools and providing an overview of the new WQX features and functions to get you on your way as smoothly as possible For more information about this service please contact Doug Mack at mackd us ibm com or send an email to QU2 us ibm com 13
Download Pdf Manuals
Related Search