DataManagement

CTI/IVR(Business Analysis)Development

I am new to Business Analyst role for Call Center and have a tough boss. She has assigned me to develop business requirements all alone on the CTI/IVR project for a telecom organization (our client). Unfortunately I don't even know how to start. Neither any helping material is available in our...

MQ Series processes issue

we've noticed on multiple servers that we have multiple instances of amqzxm0.exe, amqzllp0.exe, amqzlaa0.exe, amqzfuma.exe, amqxssvn.exe, amqrrmfa.exe, amqpcsea.exe, amqhasmn.exe and amqmtbrn.exe running in task manager. we run MQ Series version 5.2 on a windows 2000 server and while it doesn't...

Best rules of thumb?

What are five best rules of thumb when reviewing output from system monitors for preventing future problems. The system monitors could be any SMF/RMF MICS TSO/MON MXG OMEGAMON system monitor type report for reporting on the mainframe. Example might be 1. sustained CPU utilization over 85% 2....

DB2 SQL delete to purge Header/Detail records

I have a Header file with Detail records that belong to it. I need to copy the detail data off to a backup file, delete the detail records where the Header record entered date is greater than xx days from the current date, copy the header data off to a backup file and finally delete the header...

Cobol, DB2, and DDS

Am finally starting to move S/36 apps to native OS400! How do you use DDS to define repeating data, for example, a table in a file using the OCCURS clause ... 05 YTD-SALES OCCURS 12 TIMES PIC S9(8)V99 05 YTD-BUDGETS OCCURS 12 TIMES ... I suppose you could just define an area in DDS of X(120)...

Business Analysis and Project Management Documents

I am looking for document templates related to Project Management, Business Analysis and Quality Assurance. Please help and this is purely for learning purpose as I am new to the North American industry. You can take out all the confidential information. naveed@convermation.com

blanks ('') instead of NULL's in SQL Server 2000

I have a development team that wants to represent all fields with no values with a '' (blank) instead of using the database standard of NULL. The team is coding in C#. I am told it is easier for them to code around blanks than NULL's. Aside from taking up more space in the database than is...

Managing Third Party Interfaces of Large System Conversion

Good morn, This is more of a PM question, but I'll throw it out there ... any feedback would be greatly appreciated? What is the best method for managing 3rd Party Interfaces of a large system conversion? The company is converting its core mission critical system which has an immediate impact...

Question about IT management software-2

Hello, I am just wondering if anyone knows of some software avialable for IT departments, that say is accessable to users through a company intranet site where a user can go in and log an issue or problem with thier system which goes into a database, then once the issue is resolved the user can go...

Question about IT management software

Hello, I am just wondering if anyone knows of some software avialable for IT departments, that say is accessable to users through a company intranet site where a user can go in and log an issue or problem with thier system which goes into a database, then once the issue is resolved the user can go...

Data Conversion on IBM AS/400

Hi, We're converting some old master files in to new format files. These master files have around 58 million records each. We wrote COBOL programs to convert the format and write to the new files. In order to speed up the process we are splitting the each master file into 20 parts(i.e., 20 files...

DB2/400 SQL Sub Query Performance?

Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from...

Excel Help

What I have now is a simple excel spreadsheet to input numbers and info. What I want to do with it is make it a template and have one cell in the top left corner to add a new number in order each time a new user opens it. For example in the cell would be number 123 and the next time when someone...

Datawarehouse building - datamart specification: how would you engage a scattered userbase?

We are currently building a datawarehouse and will need to engage the customers in order to successfully specify the datamarts, a search functionality, etc. All of the technicalities are scoped and being put in place. The question hence directs itself to successfully engaging the customer base,...

Oracle In Linux

How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

Db2 to Oracle porting

I am in the process of planning to port a running DB2 instance on an IBM Mainframe to Oracle 9i running on Unix. Has anyone done does this before ? If yes, what should I be looking out for ? Any particular advice ? Thanks and Regards, Debu

Mainframe sunset

Our user departments have been talking about getting off the mainframe over the last several years. Recently, our CIO informed department heads that we would discontinue the mainframe by the end of 2007. It is possible that these departments could decide, "we really didn?t mean it" and push back,...

SQL Server ODBC Configuration

I've got an NT web server in our DMZ that can't connect to an internal SQL Server 7 db on W2k box. Internally we have 2 domains. ODBC returns access denied/can't find server. When I put the websrv inside our net, ODBC works fine. Other servers in DMZ can connect to db. What is going on?

SQL View over a table with members

Hi all, I have an as/400 table(fileA) with several members, I need to create view that joins this to several other tables but but I need to only target one member in fileA. The other tables are all single member tables. I tried to create an alias over the table and then create the view but that...

Starting isql*plus

Hi every one! I know that to start isql*plus in a browser, you are supposed to type something like: http://localhost:<port_number>/isqlplus Problem is, how do you determine the localhost and port number? Second, how can i use Enterprise manager to create reports about my tables in the Oracle...