January 8, 2009 07:54pm pst

1. daveslash 2,000
2. murphey2 1,900
3. wacarr 1,000
4. daveslater 800
5. tliotta 400
5. shalomc 400

1. tliotta 126,776
2. Gary_Th... 113,626
3. murphey2 53,098
4. _b_h 41,873
5. daveslash 39,227
6. daveslater 19,627
7. Kdo 19,036
8. momi_sa... 10,900
9. rward 10,100
10. shalomc 9,942
11. bggauth 5,575
12. LewisPo... 5,290
13. ajut400 4,900
14. WaldenL 3,275
15. dfke 3,200
16. nmcdermaid 3,000
17. giltjr 2,525
18. mark_wills 2,500
19. twahelpd... 2,450
20. JBart_17 2,400
21. Muflone 2,240
22. DaveMon 2,000
22. meverest 2,000
22. frankytee 2,000
22. regsworld 2,000
22. jazzIIIlove 2,000
22. Programmi... 2,000
22. JHammerer 2,000
22. larksys 2,000
22. NJComput... 2,000
22. jerryscole 2,000
22. mwvisa1 2,000
22. steveberz... 2,000
22. Infinity08 2,000
22. dmerrow 2,000

10.27.2008 at 07:58AM PDT, ID: 23850643

	[x] Attachment Details

as400 i5 restore data library with no logical files to system with logical files

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

9.4

Zones:

AS / 400, Programming for iSeries / AS400, DB2 Database

Tags:

as400 i5 restore data library logical files

General scenario:

* I have two as400 i5 systems with identical data library structure and physical files.
* Development system has new logical files against the physical files.
* Production system does not have those new logical files.
* I need to restore (refresh) from production data library to same development library.

* Specific scenario 1: the new logical files on the development system are in the same library as the physical files on the development (and corresponding) library in production

* Specific scenario 2: the new logical files on the development system are in a different library than the physical files on the development (and corresponding) library in production

Additional information:
* I am not the as400 i5 systems manager but I was notified that the most recent restore from production to development of the data library failed because the new logical files in development were in a different library than the physical files
* The new development logical files were deleted from development and the restore was successfully performed.
* The new logical files have been recreated on the development system so that they now reside in the same library as the physical files

Special information:
* The new logical files were created automatically by the i5 os as a result of SQL "create index" commands.
* They are not like old-fashioned logical files in that they do not have DDS source files.
* I have found that they could have DDL source files, but they do not at this time.

Questions:
* The as400 i5 systems manager is capable but relatively new to the as400 i5. He did not have detailed information about the problem. What might have been the problem?
* Was the problem related to the fact that the development logical files in question where in a different library than the physical files, and the restore of just the data library failed because of that?
* Will placing the new logical files on the development system in the same library as the physical files fix the problem?
* Is the problem actually that logical files exist on the development system and not on the production system?
* If restoring just a data library from production to development, must any logical files on the development system have to already exist in the production library being restored?
* Will the development logical files that do not exist in production be wiped out upon restore from production to development?
* How does the fact that these new logical files are not traditional DDS logical files fit into the scenario in general.

I know that some of the questions above may be redundant or inter-related, but I am trying to nail down just what I need to do to ensure that development library restore/refresh from production does not prohibit logical file creations in development.
Also, my question applies to traditional logical files as well as new DDL logical files. The answer may be the same or not. I apologize for the broad nature of this question. I am hoping that there is a general answer that applies to all logical files regardless of type.

Thank you for any and all help, as we are about to restore/refresh from production to development again very soon and I need some guidance in this area.

#	Title
1	Drawback of AS400
2	design AS400 sign on screen
3	Copy files from one AS400 to anoth…
4	as400 question
5	AS400 Security Log Searching
6	Getting an AS400 to send an email