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 [...]
Answer Question
| October 25, 2004 7:58 PM
Business/IT alignment, Corporate portal applications, DataCenter, Desktops, E-mail applications, Exchange, Hardware, Help Desk, Implementation, IT architecture, Knowledge management applications, Lotus Domino, Migration/Upgrades, Mobile devices, Network management software, Networking, Outlook, Planning, Security, Security management, Systems management software, Tech support
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 [...]
Answer Question
| October 25, 2004 7:58 PM
Business/IT alignment, Corporate portal applications, DataCenter, Desktops, E-mail applications, Exchange, Hardware, Help Desk, Implementation, IT architecture, Knowledge management applications, Lotus Domino, Migration/Upgrades, Mobile devices, Network management software, Networking, Outlook, Planning, Security, Security management, Systems management software, Tech support
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 and [...]
Answer Question
| October 27, 2004 2:00 AM
COBOL, Data analysis, DataCenter, Development, Disaster recovery software, ERP, Financial services applications, Help Desk, Incident response, Lifecycle development, Manufacturing applications, Office Applications, Programming Languages, RPG, Special-purpose software, SQL, Storage, SunGard Data Systems, Systems Union Group, Tech support, Transaction Systems Architects
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 and [...]
Answer Question
| October 27, 2004 2:00 AM
COBOL, Data analysis, DataCenter, Development, Disaster recovery software, ERP, Financial services applications, Help Desk, Incident response, Lifecycle development, Manufacturing applications, Office Applications, Programming Languages, RPG, Special-purpose software, SQL, Storage, SunGard Data Systems, Systems Union Group, Tech support, Transaction Systems Architects
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 INVEHD where EVENT in (Select EVENT from INVEHH where (EVHYY*10000 [...]
Answer Question
| October 20, 2009 8:40 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, DB2 Universal Database, UDB for iSeries/i5
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 INVEHD where EVENT in (Select EVENT from INVEHH where (EVHYY*10000 [...]
Answer Question
| October 20, 2009 8:40 AM
Data warehousing/Business intelligence, Database Management Systems, DB2, DB2 Universal Database, UDB for iSeries/i5
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 [...]
Answer Question
| October 26, 2004 9:16 AM
Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, Hardware, Microsoft Systems Management Server, Networking, Programming Languages, Security, Systems management software, Tech support, VBA, VBScript, Visual Basic
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 [...]
Answer Question
| October 26, 2004 9:16 AM
Database Management Systems, DataCenter, Desktop management applications, Desktops, Development, Hardware, Microsoft Systems Management Server, Networking, Programming Languages, Security, Systems management software, Tech support, VBA, VBScript, Visual Basic
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, without whose input this could never be successful. Some [...]
Answer Question
| October 12, 2004 10:43 AM
Data analysis, Data warehousing applications, DataCenter, ERP, Financial services applications, Implementation, Information risk management, Knowledge management applications, Remote users, Transaction Systems Architects
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, without whose input this could never be successful. Some [...]
Answer Question
| October 12, 2004 10:43 AM
Data analysis, Data warehousing applications, DataCenter, ERP, Financial services applications, Implementation, Information risk management, Knowledge management applications, Remote users, Transaction Systems Architects
Oracle In Linux
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.
Answer Question
| June 15, 2010 1:41 AM
Administration, AMD PC hardware, Data warehousing/Business intelligence, Database Management Systems, DB2, Development, Hardware, Implementation, Installation/Upgrade, MySQL, Operating system platforms, Oracle, Oracle 8i, Oracle 9i, OS/390, Performance/Tuning, PostgreSQL, Security products, Servers, SQL, SQL Anywhere Studio/M-Business Anywhere/Avantgo, Standard Edition, Standard One Edition, Storage, Storage management, Tech support, UDB for mainframe, Unisys, z/OS
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
Answer Question
| October 13, 2004 3:37 PM
Database Management Systems, DB2, Oracle
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
Answer Question
| October 13, 2004 3:37 PM
Database Management Systems, DB2, Oracle
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, but the mainframe-associated costs need to [...]
Answer Question
| January 4, 2008 11:36 AM
390, DB2, Mainframe
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, but the mainframe-associated costs need to [...]
Answer Question
| January 4, 2008 11:36 AM
390, DB2, Mainframe
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 [...]
Answer Question
| October 4, 2004 11:58 AM
Database Management Systems, SQL Server, Tech support
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 [...]
Answer Question
| October 4, 2004 11:58 AM
Database Management Systems, SQL Server, Tech support
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 [...]
Answer Question
| January 10, 2011 9:42 AM
DB2, UDB for iSeries/i5
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 [...]
Answer Question
| January 10, 2011 9:42 AM
DB2, UDB for iSeries/i5
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 database? Thanx.
Answer Question
| September 29, 2004 6:48 PM
Database issues, Database Management Systems, in use in organization, s, Total size of the database, Very Large Databases
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 database? Thanx.
Answer Question
| September 29, 2004 6:48 PM
Database issues, Database Management Systems, in use in organization, s, Total size of the database, Very Large Databases
Installing Oracle 9i Standard Edition on Windows Server 2003 with Xeon CPU: Why does Java Virtual Machine fail?
We are replacing an old NT 4.0 server with a new Windows Server 2003, the new hardware (a Compaq ProLiant) equipped with Intel Xeon CPU. The old server was running a couple of database instances in Oracle 8i Standard Edition, which we want/need to replace with the 9i version. The installation files for the relevant [...]
Answer Question
| October 6, 2004 5:39 AM
Database Management Systems, Hardware, Intel PC hardware, Intel servers, Java, Microsoft Windows, Oracle, Standard Edition, Tech support, Windows on Intel, Windows Server 2003
We are replacing an old NT 4.0 server with a new Windows Server 2003, the new hardware (a Compaq ProLiant) equipped with Intel Xeon CPU. The old server was running a couple of database instances in Oracle 8i Standard Edition, which we want/need to replace with the 9i version. The installation files for the relevant [...]
Answer Question
| October 6, 2004 5:39 AM
Database Management Systems, Hardware, Intel PC hardware, Intel servers, Java, Microsoft Windows, Oracle, Standard Edition, Tech support, Windows on Intel, Windows Server 2003
Mainframe security / Racf
My first time on ITKE , so please forgive, but why do I not see any RACF/Top Secret/ACF2 related issues? It should be under security, or not ? Thanks Pieter
Answer Question
| September 29, 2004 9:54 AM
390, DB2, Mainframe, Security management
My first time on ITKE , so please forgive, but why do I not see any RACF/Top Secret/ACF2 related issues? It should be under security, or not ? Thanks Pieter
Answer Question
| September 29, 2004 9:54 AM
390, DB2, Mainframe, Security management
MIgrating SQL Server 2000 to Active Directory
When migrating a Server that hosts a SQL Server 2000 Instance from an NT Domain to an Active Directory Domain, What, if anything, needs to be done withing SQL Server for everything to work properly???? Since migrating the host Server to AD, my NT Authenticated SQL Server Logins are not working properly (Server and accounts [...]
Answer Question
| September 20, 2004 12:40 PM
Biometrics, Database Management Systems, Digital certificates, Identity & Access Management, provisioning, Security tokens, Single sign-on, SQL Server, Standard Edition 2000, Tech support
When migrating a Server that hosts a SQL Server 2000 Instance from an NT Domain to an Active Directory Domain, What, if anything, needs to be done withing SQL Server for everything to work properly???? Since migrating the host Server to AD, my NT Authenticated SQL Server Logins are not working properly (Server and accounts [...]
Answer Question
| September 20, 2004 12:40 PM
Biometrics, Database Management Systems, Digital certificates, Identity & Access Management, provisioning, Security tokens, Single sign-on, SQL Server, Standard Edition 2000, Tech support
How to alter more than one existing columns in SQL 2000 Server?
I m working in SQL Server(2000) Enterprise Edition.When I m using “Alter Table <tablename> Alter Column <column name> (column definition)” for only 1 column then its working (using Query Analyzer). However when I m trying to alter more than 1 column, Query Analyzer is giving error messages (syntax error).Pls suggest ways.
Answer Question
| September 14, 2004 7:05 AM
Database Management Systems, SQL Server
I m working in SQL Server(2000) Enterprise Edition.When I m using “Alter Table <tablename> Alter Column <column name> (column definition)” for only 1 column then its working (using Query Analyzer). However when I m trying to alter more than 1 column, Query Analyzer is giving error messages (syntax error).Pls suggest ways.
Answer Question
| September 14, 2004 7:05 AM
Database Management Systems, SQL Server
Openings for experienced consultants-2
I am conducting searches for consultants in ERP Financial, Distribution, Pharma, Travel/Entertainment, Transportation industries, CRM, SAP, Oracle, PeopleSoft, analysts, business developers, architects, data warehousing and data mining consultants. Can be based anywhere in the US. Please contact me for more info. thank you Laurie
Answer Question
| August 21, 2004 7:14 PM
Data analysis, Data warehousing applications, ERP, Microsoft Windows
I am conducting searches for consultants in ERP Financial, Distribution, Pharma, Travel/Entertainment, Transportation industries, CRM, SAP, Oracle, PeopleSoft, analysts, business developers, architects, data warehousing and data mining consultants. Can be based anywhere in the US. Please contact me for more info. thank you Laurie
Answer Question
| August 21, 2004 7:14 PM
Data analysis, Data warehousing applications, ERP, Microsoft Windows
Openings for experienced consultants
I am conducting searches for consultants in ERP Financial, Distribution, Pharma, Travel/Entertainment, Transportation industries, CRM, Oracle, PeopleSoft, analysts, business developers, architects, data warehousing and data mining consultants. Can be based anywhere in the US. Please contact me for more info. thank you Laurie
Answer Question
| August 18, 2004 7:13 PM
Data analysis, Data warehousing applications, ERP, Microsoft Windows
I am conducting searches for consultants in ERP Financial, Distribution, Pharma, Travel/Entertainment, Transportation industries, CRM, Oracle, PeopleSoft, analysts, business developers, architects, data warehousing and data mining consultants. Can be based anywhere in the US. Please contact me for more info. thank you Laurie
Answer Question
| August 18, 2004 7:13 PM
Data analysis, Data warehousing applications, ERP, Microsoft Windows
Scanning Documents into SAP
Does anyone know of a way to scn documents into the SAP database quickly and easily ?? Is it possible to scan froma workstation and integrate via SAPGUI components somehow? I am seeking an easy way to get paper documents into the database without having to gather them all up centrally first. It is really [...]
Answer Question
| August 17, 2004 2:01 AM
ERP, IT architecture, SAP
Does anyone know of a way to scn documents into the SAP database quickly and easily ?? Is it possible to scan froma workstation and integrate via SAPGUI components somehow? I am seeking an easy way to get paper documents into the database without having to gather them all up centrally first. It is really [...]
Answer Question
| August 17, 2004 2:01 AM
ERP, IT architecture, SAP
API viewer or log
We are developing a product to run on top of or beside Lotus Notes/Domino. Does anyone know of a tool that will allow us to monitor what each program is doing from an API perspective? I’m looking for this tool from a QA Tester point of view. The tool can be a live or logged [...]
Answer Question
| August 6, 2004 12:43 PM
Development, E-mail applications, Knowledge management applications, Lotus Domino, Software testing, Software testing tools
We are developing a product to run on top of or beside Lotus Notes/Domino. Does anyone know of a tool that will allow us to monitor what each program is doing from an API perspective? I’m looking for this tool from a QA Tester point of view. The tool can be a live or logged [...]
Answer Question
| August 6, 2004 12:43 PM
Development, E-mail applications, Knowledge management applications, Lotus Domino, Software testing, Software testing tools
Alternate way to stop Oracle Services on Win 2K Server-2
Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup [...]
Answer Question
| August 2, 2004 2:25 PM
configuration, Database Management Systems, DataCenter, Desktop security, Hardware, Oracle, Oracle 8i, Oracle Application Server, patching, PEN testing, Platform Security, Policies, Security, Servers, Software distribution, Standard Edition, vulnerability management, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance
Our database server is a Machine running Windows 2K Server. We make our backups stopping the Oracle Service and then copying the files to other location (and then to tape), but in order to do this, the user loged in on the server must be an administrator, and this is a problem, because the backup [...]
Answer Question
| August 2, 2004 2:25 PM
configuration, Database Management Systems, DataCenter, Desktop security, Hardware, Oracle, Oracle 8i, Oracle Application Server, patching, PEN testing, Platform Security, Policies, Security, Servers, Software distribution, Standard Edition, vulnerability management, Windows, Windows 2000 desktop, Windows 2000 Server, Windows client administration and maintenance
