Back up encryption
I’m trying to develop a backup strategy for my company who has two iSeries, one on East coast & one on West coast. Currently we backup to tape and the data is encrypted as the tapes go off-site for storage. I was hoping to do something like ‘cross-site’ mirroring between the two iSeries to satify [...]
Answer Question
| January 30, 2008 4:44 PM
Backup & recovery, iSeries
I’m trying to develop a backup strategy for my company who has two iSeries, one on East coast & one on West coast. Currently we backup to tape and the data is encrypted as the tapes go off-site for storage. I was hoping to do something like ‘cross-site’ mirroring between the two iSeries to satify [...]
Answer Question
| January 30, 2008 4:44 PM
Backup & recovery, iSeries
Constraint Recovery
Asked on behalf of TimSki37: Is it possible to recover or restore database constraints in a schema/library that has been cleared and restored from a different schema/library? We have a library that was cleared of all physical files and tables were restored from a different library. In doing so, however, all constraints were lost and [...]
Answer Question
| February 13, 2009 1:40 PM
AS/400, Backup, Backup & recovery, iSeries
Asked on behalf of TimSki37: Is it possible to recover or restore database constraints in a schema/library that has been cleared and restored from a different schema/library? We have a library that was cleared of all physical files and tables were restored from a different library. In doing so, however, all constraints were lost and [...]
Answer Question
| February 13, 2009 1:40 PM
AS/400, Backup, Backup & recovery, iSeries
Source Modified User
Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy
Answer Question
| December 11, 2007 5:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Hi All, If 4 users works on in same library in one source file, How could we know which user has modified a source? Thanks Reddy
Answer Question
| December 11, 2007 5:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Why did Go Backup not save certain files?
I ran Go save Option 21 yesterday on our new Iseries. Its running V5R4M0. Then last night I set up the daily backup to run in GO BACKUP, it saved over 4000 objects but for some reason wouldnt backup 39 objects. 5 of them in QUSRSYS (QAOKP01a and 4 others with similar names), also in [...]
Answer Question
| July 7, 2007 1:14 PM
Backup & recovery
I ran Go save Option 21 yesterday on our new Iseries. Its running V5R4M0. Then last night I set up the daily backup to run in GO BACKUP, it saved over 4000 objects but for some reason wouldnt backup 39 objects. 5 of them in QUSRSYS (QAOKP01a and 4 others with similar names), also in [...]
Answer Question
| July 7, 2007 1:14 PM
Backup & recovery
AS400
hi, i want to know about the answers of these questions.. 1.) If any data has been deleted from the PF then how can we recover that and what are the limitiations for that. 2.) If in run time user want to choose the Access Path of a PF then how can it be possible.
Answer Question
| December 20, 2007 2:50 PM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security
hi, i want to know about the answers of these questions.. 1.) If any data has been deleted from the PF then how can we recover that and what are the limitiations for that. 2.) If in run time user want to choose the Access Path of a PF then how can it be possible.
Answer Question
| December 20, 2007 2:50 PM
Application development, AS/400, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security
Converting from System 36 to iSeries V5R4
I’ve been landed with a project to convert a System 36 system to iSeries 520 with OS V5.4. I have never worked on a System 36 and do not know where to start. Have looked for some documentation in Red Books but could’nt find anything. Does anyone have something I can use – something like [...]
Answer Question
| April 30, 2012 4:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, RPG, RPGLE
I’ve been landed with a project to convert a System 36 system to iSeries 520 with OS V5.4. I have never worked on a System 36 and do not know where to start. Have looked for some documentation in Red Books but could’nt find anything. Does anyone have something I can use – something like [...]
Answer Question
| April 30, 2012 4:25 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, RPG, RPGLE
How to unsubscribe
I am getting ready to Retire from my current employer. I will not be working in this field as I have started a very different and unique business. have looked all around to find out how to unsubscribe but can not easily find out how. If anyone knows how, please let me know.
Answer Question
| June 11, 2007 4:25 PM
AS/400, AS/400 careers, Backup & recovery, Career development, CRM, E-business, Instant Messaging, Partner facing, Web services, Web site design & management
I am getting ready to Retire from my current employer. I will not be working in this field as I have started a very different and unique business. have looked all around to find out how to unsubscribe but can not easily find out how. If anyone knows how, please let me know.
Answer Question
| June 11, 2007 4:25 PM
AS/400, AS/400 careers, Backup & recovery, Career development, CRM, E-business, Instant Messaging, Partner facing, Web services, Web site design & management
Tracking Changes to Files
Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. [...]
Answer Question
| August 13, 2007 5:44 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Requirement:- To track any changes to Two files A and B and write fields of A and B to an output file C. A is related to B (A.Employee = B.Employee) Could you please suggest a good approach for this? I am currently using the approach of journalling. 1. Both A and B are journalled. [...]
Answer Question
| August 13, 2007 5:44 AM
Application development, AS/400, AS/400 careers, Backup & recovery, CLP, DataCenter, DB2 Universal Database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Web development
Type of storage/backup solution
Hey everyone, I just started with a medium sized business doing IT work, and they have asked me to research types of backup solutions. At this point we are running a server that holds about 350 GB of data, and we have 2 remote offsite locations which they would also like to back up as [...]
Answer Question
| February 5, 2010 3:27 PM
Backup & recovery, iSCSI, NAS, Online Backup, SAN, Storage management, Storage products and equipment, Storage servers, Windows storage
Hey everyone, I just started with a medium sized business doing IT work, and they have asked me to research types of backup solutions. At this point we are running a server that holds about 350 GB of data, and we have 2 remote offsite locations which they would also like to back up as [...]
Answer Question
| February 5, 2010 3:27 PM
Backup & recovery, iSCSI, NAS, Online Backup, SAN, Storage management, Storage products and equipment, Storage servers, Windows storage
BRMS Media Movement
Does anyone know how to find out the move status of a tape in BRMS?
Answer Question
| May 2, 2007 3:34 PM
AS/400, Backup & recovery
Does anyone know how to find out the move status of a tape in BRMS?
Answer Question
| May 2, 2007 3:34 PM
AS/400, Backup & recovery
In RPG program
Hi, In RPG program i declared files. One for reading and another for Updating. Both the files are in different Library lists. How do i achieve this???? Thanks in Advance Rama krishna
Answer Question
| January 18, 2010 1:30 PM
Application development, AS/400, Backup & recovery, CLP, RPG, RPGLE
Hi, In RPG program i declared files. One for reading and another for Updating. Both the files are in different Library lists. How do i achieve this???? Thanks in Advance Rama krishna
Answer Question
| January 18, 2010 1:30 PM
Application development, AS/400, Backup & recovery, CLP, RPG, RPGLE
Error in a Group of Called Programs
Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC…….so on…10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this??? Thanks in Advance, [...]
Answer Question
| April 26, 2007 12:16 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
Hi, I have a CL program, it calls 10 other programs i.e. pgmA, pgmB, pgmC…….so on…10 programs. While running the CL program error occurred in pgmC. I rectified that error. After rectification once again I will run the CL Program. Now my execution must start from pgmC. How do i do this??? Thanks in Advance, [...]
Answer Question
| April 26, 2007 12:16 PM
Application development, AS/400, Backup & recovery, CLP, DB2 Universal Database, RPG, RPGLE
Impact analysis
Hi, The user requested me to change the field length from 25 to 30 char. I want to do impact analysis on this. How do i proceed?? Thanks, Rama Krishna
Answer Question
| January 12, 2010 8:40 AM
Application development, AS/400, Backup & recovery, CLP, RPG, RPGLE
Hi, The user requested me to change the field length from 25 to 30 char. I want to do impact analysis on this. How do i proceed?? Thanks, Rama Krishna
Answer Question
| January 12, 2010 8:40 AM
Application development, AS/400, Backup & recovery, CLP, RPG, RPGLE
How to reset the password??
Hi, How to reset the password through a CL program. The user has forgotten his password, even ADMIN doesn’t know the password. Thanks, Rama krishna
Answer Question
| January 29, 2010 8:29 AM
AS/400, Backup & recovery, CLP, RPG, RPGLE, Security
Hi, How to reset the password through a CL program. The user has forgotten his password, even ADMIN doesn’t know the password. Thanks, Rama krishna
Answer Question
| January 29, 2010 8:29 AM
AS/400, Backup & recovery, CLP, RPG, RPGLE, Security
Accessing the other users object.
Hi, I donot have authority to access another users object. I donot know the userid or password of that user. How to get access to it?? Thanks, rama krishna
Answer Question
| January 8, 2010 5:53 AM
AS/400, Backup & recovery, DataCenter, RPG, RPGLE, Security
Hi, I donot have authority to access another users object. I donot know the userid or password of that user. How to get access to it?? Thanks, rama krishna
Answer Question
| January 8, 2010 5:53 AM
AS/400, Backup & recovery, DataCenter, RPG, RPGLE, Security
Copying Spoolfiles
Hi, I would like to know, How to copy spoolfiles from one AS400 machine to another AS400 machine? Thanks in Advance Rama Krishna
Answer Question
| January 8, 2010 5:41 AM
Application development, Backup & recovery, DataCenter, RPG, RPGLE, Security
Hi, I would like to know, How to copy spoolfiles from one AS400 machine to another AS400 machine? Thanks in Advance Rama Krishna
Answer Question
| January 8, 2010 5:41 AM
Application development, Backup & recovery, DataCenter, RPG, RPGLE, Security
media recovery
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide [...]
Answer Question
| April 10, 2007 5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files & tablespaces offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide [...]
Answer Question
| April 10, 2007 5:04 AM
7 and earlier, Architecture/Design, Availability, Backup & recovery, BPEL, Business Process Execution Language, Database, DB2, Installation, Java/J2EE, Migration, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, Oracle administration, Oracle Database Versions, Oracle development, Performance/Tuning, PHP, Security, Service-Oriented Architecture, SOA, SQL, Windows, XML
Best way to do the DASD history capture…(Disk usage)
Dear team, i need to enhance our current system that captures the disk space uasge. i need to maintain the history over it. currently we do it by using DSPOBJD and DSPFD commands and write the details of all objects and files used in the whole system to the outfile.Hardly it takes more than 4 [...]
Answer Question
| January 8, 2010 1:03 AM
Backup & recovery, CRM, DataCenter, RPGLE
Dear team, i need to enhance our current system that captures the disk space uasge. i need to maintain the history over it. currently we do it by using DSPOBJD and DSPFD commands and write the details of all objects and files used in the whole system to the outfile.Hardly it takes more than 4 [...]
Answer Question
| January 8, 2010 1:03 AM
Backup & recovery, CRM, DataCenter, RPGLE
moving datafiles to different locations
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide me. Regards.
Answer Question
| March 26, 2007 12:18 PM
Backup & recovery, Performance/Tuning
Hi, Please help. I want to shift my datafiles from c: to S:. I have made a physical copy of dbf files from c: to s:. In Oracle 10g I made those files offline and renamed with new physical location. when bringing online I was getting error as “need media recovery”. Please Guide me. Regards.
Answer Question
| March 26, 2007 12:18 PM
Backup & recovery, Performance/Tuning
OBJECT AUTHORITY TO ONE USER TO DELETE OTHERS OBJECTS
On a i5 V5R4 an AS400 analyst who has 3 junior programmers working under him is not able to delete objects created by them. All these objects are in a shared library with a *all permission to all of them including the analyst. Since the analyst is not the owner of the object, he is [...]
Answer Question
| January 3, 2010 5:09 AM
AS/400, Backup & recovery
On a i5 V5R4 an AS400 analyst who has 3 junior programmers working under him is not able to delete objects created by them. All these objects are in a shared library with a *all permission to all of them including the analyst. Since the analyst is not the owner of the object, he is [...]
Answer Question
| January 3, 2010 5:09 AM
AS/400, Backup & recovery
