tao's profileDragon's RoomPhotosBlogListsMore Tools Help

Dragon's Room

tao harry

Interests
No list items have been added yet.
Photo 1 of 12
More albums (1)
Public folders
December 17

数据库还原的SQL 命令

还是直接sql操作比较好
 
/*-------------------------------------------------------------------------------------------------*/
添加_还原数据库
exec sp_attach_db 'database_name',
     'G:\data\SQLData\Asset_data.mdf',
     'G:\data\SQLData\Asset_log.ldf'
June 14

创建大型机内自己的编译命令

            
在大型机内可以利用IBM提供的作业进行COBOL程序的编译,但是我们也可以利用ISPF MACRO来创建自己的便捷编译命令。
搞里一个星期,昨晚终于在荷兰与法国的激战中华丽的实现了...
 
1. 创建编译中用到的data set。  

2. command中使用ddlist查看sysproc下的data set。 如果有管理员权限。建议在已经有的clist的data set中创建MACRO.
如果要在新的data set中创建,需要在创建data set后使用一下代码,才会有效(SAMPLE):
FREE FI(SYSPROC)                                                       
ALLOC FI(SYSPROC) DA('ISP.SISPCLIB'    +             
                     'G420985.HARRY.MACRO') SHR REU  
3. 在USER.CLIST中创建自己的MACRO,代码如下:
4. 写个hello world并用TRNGCOB命令直接编译:
到LOADLIB中查看下:
编写JCL提交作业:
到SDSF中查看结果
大功告成!
总的来说这样,节省了不少编译的时间,用同样的方法亦可以实现包含DB2,CICS的COBOL编译。
 
 
May 30

SDSF下一个很有用的命令

最近在作大型机的模拟机
初次模拟成功很不错  不过也遇到了一个问题
就是在提交JCL后在SDSF中看不到相关的job信息
最初以为是SDSF没有配置好
后来问了同事才知道 SDSF好像是默认不显示之前已经执行了的job的--- 这个说法目前还有待证明。。
不过用一个命令 可以显示出你想看到的job信息
 
PRE *     显示之前所有job
Pre off    不显示之前的job
更多信息可以参考IBM的SDST手册
May 29

Mastering the Art of Team Building

今天看到一篇文章

如果你将要领导一个团队 应该会有所帮助的

No business or industry could really make it big without the cooperative efforts of its supervisors and workers. The demands of modern business as a fast paced environment has made teamwork and cooperation an essential part of business success. Recent business developments show that there is a move towards mergers and free markets are being established.

Competition is becoming greater and therefore it is necessary for people running a business or industry to put their acts together to be able cope with growing demands and fast changes. A high level of productivity is always attributed to personnel cohesiveness in the company.

A broad understanding of the objectives and mission of the company is the basis for building teamwork. Management should see to it that every worker should feel that he or she is not just doing the job require but is actually fulfilling the grand objective of the company. Employees have to understand that they are an integral part of the big picture which is the company and the picture would not be complete without them doing his job. Successful businesses has well-motivated personnel.

Personnel development is also essential for effective team building. There should be continuous effort to enhance personnel capability and teamwork thru seminars, in-service trainings and frequent meetings. Whenever there are problems which affect personnel cohesiveness, management should see to it that these are resolved immediately.

Personnel commitment is an important aspect which management should take into serious consideration. The challenge given to workers should be appropriately recognized and compensated whenever they accomplish they accomplish well in their given task.

A good team is composed of competent people who are able to contribute to the success of the team. Everyone is able to perform as expected. A company should have a leadership team which leads the way for the support group. Communication lines among the group members should always be open.

Employees should feel that they are empowered to do their job in the most suitable manner and environment. Limitations should be recognized and the leadership should be ready and prepared to address these limitations. Members should also feel that they are accountable for everything they do and that they maintain good relationship with each other.

The team should also have an established feedback system. Records and reports are important in order to be able to recognize the strengths and weaknesses of the team. Norms and rules should be firmly in place to guide members how to resolve conflicts and make decisions on important matters.

Workers should also be guided by formulated action plans and appropriate strategies. Personnel performance and achievement are assessed based on how they are able to work according to the plan and strategies formulated by the leadership.

Personnel should at all times be encouraged to be innovative and creative. Rewards and incentives should be given to members who contribute brilliant new ideas and take reasonable risks just to be able to make improvements on the job assigned to them. Research is an important matter in order to make improvements. Management should see to it that research tools and materials are accessible to the team members.

Team members should be have a clear view of the company and the nature of their contribution, empowered to work collaboratively according to specified norms, given enough room for improvement and creativity, well-compensated and maintains constant communication with each the leadership and each other.

May 12

Central Storage Protection

Protection of Central Storage is necessary to keep one application from intentionally or accidentally harming another application - including MVS and its subsystems. Central Storage protection is implemented by assigning attribute to Central Storage page frames.

一般来说有四种策略:

(a)     Storage key Protection

EC mode and BC mode

(b)     Segment Protection

64K segment and read only

(c)     Low Address Protection (LAP)

first 512byte

(d) Page Protection of System Areas

use the storage key to protection.

 

May 09

Mainframe Refresh - MVS - Introduction to Mainframe Computing

Introduction to Mainframe Computing

1.1 CLASSIFICATION OF COMPUTERS

According to the hardware complexity, OS complexity and nature of application program, there are four types of computers as follow:

Micro computer

Mini computer

Mainframe

Supercomputer

Though these divisions are loosely based on the size of the computer systems, there are no hard and fast rules for deciding exactly where one category ends and the next begin. Hence the largest minicomputer systems are often larger than the smallest mainframe computers.

1.2 HISTORY OF MAINFRAME

1960’s   Scientific computers IBM 704 709 7040-7044 and 7094

           Decimal computers   IBM 7070 7090

           Charters computers  IBM 1401 1410 7010

1964     S360

1972     S370

           S370/XA           S370/ESA

           S390

           ES9000

           E-Server

           Z-series


1.3 MVS EVOLUTION
1.3.1 OPERATING SYSTEM.

An operating system is a program that acts as an intermediary between user of a computer and the computer hardware.

Process management

Main memory management

Secondary storage management

I/O system management

File management

Protection

Networking

 

1.3.2 HISTORY OF AN OPERATING SYSTEM

1.   DOS     DOS/VSE     OS/360      

2.   PCP(primary control program)

      Only one program reside in main storage.CPU remain idle while waiting the I/O.

3.   MFT(OS/VS1)-Multiprogramming with Fixed Number of Tasks

      Drawback is a program has to wait a suitable partition.    

4.   MVT(OS/VS2-Singal virtual storage)- Multiprogramming with variable Number of Tasks

5.   MVS

6.   Z-series

 

*Data space VS Address Space

*Data space VS Hiperspace

1.4 CHARACTERISTIC FEATURES OF MAINFRAME OPERATING SYSTEMS
Virtual storage

Multiprogramming

Spooling

Batch processing

Time sharing
1.5. SYSTEM/370 HARDWARE CONCEPTS
1.5.1. PROCESSOR COMPLEX

CPU include register (PSW, control register, general purpose register, floating point register, access register), ALU, high speed buffer

Computer system controllers

Channels
1.5.2 UNIPROCESSING VS MULTIPROCESSING

Multiprocessor - The term refers to the ability to have more than one task executing at the same time, not just two or more tasks running in the Processor Complex at the same time, but two instructions executing at the same point of time.

Non-partitionable multiprocessors Mode

Partitionable multiprocessors Mode

PR/SM – Logically partitioned Mode


1.5.3. CENTRAL STORAGE MANAGEMENT

Types of DASD page space:

l  Hardware addressable – ROM (read only memory), which contains Microcode. Microcode as such is a set of microinstructions in the hardware that tells the hardware how to execute the instructions designated in the processor complex

l  User addressable – Central storage. 4k fixed pages (long term fixed pages and short term fixed pages)

l  System addressable: auxiliary storage. PLPA – Pageable link pack area; common area; local dataset

l  System addressable: expanded storage

&    Swap data sets contain blocks of pages, which are assigned to a task.


1.5.4 CENTRAL STORAGE PROTECTION

Storage protection key

Segment protection

LAP – low address protection

Page protection of system areas (read only, which is implemented in MVS/XA and MVS/ESA)
1.6 ESCON ARCHITECTURE (ESCD)


1.7. SYSPLEX

Full name is system complex, which is introduced in MVS/ESA.

Multiple MVS – XCF (cross-system coupling facility)
1.8 MVS SOFTWARE SERVICES

²  DAT – dynamic address translation

²  Multiprocessing

²  Multiprogramming

²  ENQUE and locking

²  Timing

²  System operator communication

²  Address space management

²  Batch job management and spooled input and output

²  Data set management and access methods

²  Program management

²  Communication software and hardware


1.9 SUBSYSTEMS AND FACILITIES

²  TSO and ISPF

²  SMS

²  JES

²  Teleprocessing

²  CICS

²  IMS

²  DB2

²  RACF – resource access control facility

²  SMF – system management facility

²  Language translators, linkage editor and the loader

²  Utility programs, such as IEBGENER

²  CLIST and REXX

September 29

 
Photo 1 of 12
More albums (1)
感谢访问!
Please wait...
Sorry, the comment you entered is too long. Please shorten it.
You didn't enter anything. Please try again.
Sorry, we can't add your comment right now. Please try again later.
To add a comment, you need permission from your parent. Ask for permission
Your parent has turned off comments.
Sorry, we can't delete your comment right now. Please try again later.
You've exceeded the maximum number of comments that can be left in one day. Please try again in 24 hours.
Your account has had the ability to leave comments disabled because our systems indicate that you may be spamming other users. If you believe that your account has been disabled in error please contact Windows Live support.
Complete the security check below to finish leaving your comment.
The characters you type in the security check must match the characters in the picture or audio.