Fixing violation errors found with CHKOBJITG
I have just begun running the command to check object itegrity on my system. I have encountered 2 basic errors – BADSIG & ALTERED. Can you please explain how I now correct these errors? The objects are basic IBM supplied code (i.e. ADDTCPLNK in QTCP library). I have no idea how these objects were compromised, [...]
Answer Question
| February 15, 2006 7:19 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
I have just begun running the command to check object itegrity on my system. I have encountered 2 basic errors – BADSIG & ALTERED. Can you please explain how I now correct these errors? The objects are basic IBM supplied code (i.e. ADDTCPLNK in QTCP library). I have no idea how these objects were compromised, [...]
Answer Question
| February 15, 2006 7:19 AM
Access control, Application security, backdoors, Biometrics, Browsers, Compliance, configuration, CRM, Current threats, Database, Digital certificates, Disaster Recovery, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network security, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Database Implementation
What is the best practice for implementation of a new Database software package (I.E. creating teams, or work with a Committee) My boss would like me to learn everyones job, is this really necessary to implement a new Database package…
Answer Question
| February 8, 2006 9:26 AM
Database, DB2, Oracle, Project management
What is the best practice for implementation of a new Database software package (I.E. creating teams, or work with a Committee) My boss would like me to learn everyones job, is this really necessary to implement a new Database package…
Answer Question
| February 8, 2006 9:26 AM
Database, DB2, Oracle, Project management
deal with microsoft access data base file from RPG program or clp
hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy
Answer Question
| November 28, 2009 12:45 PM
Application development, AS/400, CLP, DB2 Universal Database, RPGLE
hello, I need to made clp or RPG program to open microsoft access data base file from my PC then read and update special table from this file thanks best regards laila elsharkawy
Answer Question
| November 28, 2009 12:45 PM
Application development, AS/400, CLP, DB2 Universal Database, RPGLE
Oracle Sql Tuning
Hi everybody. I need some help with Sql Tuning. I have a query that returns information from many tables (let’s say 5 for the example). 2 of that tables are big tables (20 million rows each one). I usually write ‘where’ clauses putting first the join conditions and after them, the table specific conditions, but [...]
Answer Question
| February 6, 2006 2:03 PM
Database, DB2, Oracle, Windows
Hi everybody. I need some help with Sql Tuning. I have a query that returns information from many tables (let’s say 5 for the example). 2 of that tables are big tables (20 million rows each one). I usually write ‘where’ clauses putting first the join conditions and after them, the table specific conditions, but [...]
Answer Question
| February 6, 2006 2:03 PM
Database, DB2, Oracle, Windows
Synon/Cool:2E – internal/external func performance question
I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external function call it, [...]
Answer Question
| April 28, 2009 5:52 PM
Application development, AS/400, CLP, DB2 Universal Database, Development, RPG, RPGLE
I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external function call it, [...]
Answer Question
| April 28, 2009 5:52 PM
Application development, AS/400, CLP, DB2 Universal Database, Development, RPG, RPGLE
List of Values in a SP Parameter
I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin Declare C1 Cursor with Return For Select * From Table1 WHERE Field1 in(‘Value1′, ‘Value2′,’Value3′, etc);
Answer Question
| February 9, 2006 2:42 PM
Application development, Crystal Reports, DB2 Universal Database
I need to pass a List of Values parameter from a Crystal Report to a Store Procedure. 1) How do I define the Parm? and 2) How do I code the WHERE clause? Example: Result Sets 1 Language SQL Begin Declare C1 Cursor with Return For Select * From Table1 WHERE Field1 in(‘Value1′, ‘Value2′,’Value3′, etc);
Answer Question
| February 9, 2006 2:42 PM
Application development, Crystal Reports, DB2 Universal Database
Syncronize DB2 email dist list with Lotus Domino v6.5
A quick question that has us stumped here. Currently we maintian our email distribution lists in DB2 on our iSeries (810), running OS400 v5r2. We syncronize the dist lists with our Domino server (v5) using a migration tool Lotus provided. We are planning to update Domino to v6r5, and our iSeries OS to v5r3 in [...]
Answer Question
| February 2, 2006 11:38 AM
DB2 Universal Database, Lotus Domino
A quick question that has us stumped here. Currently we maintian our email distribution lists in DB2 on our iSeries (810), running OS400 v5r2. We syncronize the dist lists with our Domino server (v5) using a migration tool Lotus provided. We are planning to update Domino to v6r5, and our iSeries OS to v5r3 in [...]
Answer Question
| February 2, 2006 11:38 AM
DB2 Universal Database, Lotus Domino
A copy tool??
Hello to all, I am a COBOL programmer working for a life assurance company which uses a life assurance package developed on the iSeries. I have been tasked with looking into whether it is possible for us to copy a ‘contract/policy’ from our live environment to a development/test environment. This would involves copying all contract/policy [...]
Answer Question
| February 20, 2006 4:43 AM
Application development, AS/400, DataCenter, DB2 Universal Database, RPG
Hello to all, I am a COBOL programmer working for a life assurance company which uses a life assurance package developed on the iSeries. I have been tasked with looking into whether it is possible for us to copy a ‘contract/policy’ from our live environment to a development/test environment. This would involves copying all contract/policy [...]
Answer Question
| February 20, 2006 4:43 AM
Application development, AS/400, DataCenter, DB2 Universal Database, RPG
In VPN Which protocol to be used……??
Hiiiii everybody….. I am Bala new member of this group I have got one small querry regarding VPN, in my organization i am trying to implement VPN for the remote access, in the bangalore office i wanted to install concentrator Cisco 3015 and in the bombay and pune office i wanted to configure VPN hardware [...]
Answer Question
| February 2, 2006 2:42 AM
Access control, Application security, Availability, backdoors, Bandwidth, Biometrics, Browsers, Cisco, Compliance, configuration, CRM, Current threats, Database, DataCenter, DHCP, Digital certificates, Disaster Recovery, DNS, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Hiiiii everybody….. I am Bala new member of this group I have got one small querry regarding VPN, in my organization i am trying to implement VPN for the remote access, in the bangalore office i wanted to install concentrator Cisco 3015 and in the bombay and pune office i wanted to configure VPN hardware [...]
Answer Question
| February 2, 2006 2:42 AM
Access control, Application security, Availability, backdoors, Bandwidth, Biometrics, Browsers, Cisco, Compliance, configuration, CRM, Current threats, Database, DataCenter, DHCP, Digital certificates, Disaster Recovery, DNS, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Identity & Access Management, Incident response, Instant Messaging, Intrusion management, Network applications management, Network management software, Network monitoring, Network protocols, Network security, Networking, Networking services, patching, PEN testing, Platform Security, Policies, provisioning, Risk management, Secure Coding, Security, Security Program Management, Security tokens, Servers, Single sign-on, Spyware, SSL/TLS, Trojans, Viruses, VPN, vulnerability management, Web security, Wireless, worms
Exam question Antivirus – VPN – related
Hi I would like to offer a sincere thank you for reading this far. Im in deep trouble and need to answer a theory question for a presentation and would really appreciate any thoughts you can offer me. I only have the below information to go on and need to explain and present a soultion [...]
Answer Question
| January 29, 2006 9:11 PM
Access control, Application security, backdoors, Browsers, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Interoperability, Intrusion management, Network security, Networking, Secure Coding, Security, Servers, Software, Spyware, SSL/TLS, Tech support, Trojans, Viruses, VPN, Web security, Wireless, worms
Hi I would like to offer a sincere thank you for reading this far. Im in deep trouble and need to answer a theory question for a presentation and would really appreciate any thoughts you can offer me. I only have the below information to go on and need to explain and present a soultion [...]
Answer Question
| January 29, 2006 9:11 PM
Access control, Application security, backdoors, Browsers, Current threats, Database, Encryption, Exchange, filtering, Firewalls, Forensics, Hacking, human factors, Incident response, Instant Messaging, Interoperability, Intrusion management, Network security, Networking, Secure Coding, Security, Servers, Software, Spyware, SSL/TLS, Tech support, Trojans, Viruses, VPN, Web security, Wireless, worms
Oracle boolean data type questions
Greetings, Since Oracle Table structures do not support a boolean data type, there is a choice (Make it a varchar2(1) or Number(1)), with contents of 0,1 or Y,N The questions I have are: 1) From a comparison perspective, which provides better performance? Comparison of a number (1,0) or string (Y/N) 2) Which method takes up [...]
Answer Question
| January 28, 2006 4:15 PM
Database, DB2, Oracle
Greetings, Since Oracle Table structures do not support a boolean data type, there is a choice (Make it a varchar2(1) or Number(1)), with contents of 0,1 or Y,N The questions I have are: 1) From a comparison perspective, which provides better performance? Comparison of a number (1,0) or string (Y/N) 2) Which method takes up [...]
Answer Question
| January 28, 2006 4:15 PM
Database, DB2, Oracle
messaging and collaboration
What is messaging and collaboration,how does it works,how to set it up ,where can it be implemented and how
Answer Question
| January 12, 2008 8:40 AM
AIM, Availability, Bandwidth, Billing and customer care, Billing Support Systems, Brightmail, Budgeting, Business Objects, Business/IT alignment, Career development, Certifications, Cognos, Compliance, CRM, Crystal Reports, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, DataManagement, Development, Enterprise Desktop, ERP, Exchange, Instant Messaging, Laws, Lifecycle development, Linux, MySQL, Network monitoring, Network protocols, Networking, Outsourcing, Regulations, Spam, standards, Training, Web development
What is messaging and collaboration,how does it works,how to set it up ,where can it be implemented and how
Answer Question
| January 12, 2008 8:40 AM
AIM, Availability, Bandwidth, Billing and customer care, Billing Support Systems, Brightmail, Budgeting, Business Objects, Business/IT alignment, Career development, Certifications, Cognos, Compliance, CRM, Crystal Reports, Data analysis, Data mining/analysis, Data warehousing applications, DataCenter, DataManagement, Development, Enterprise Desktop, ERP, Exchange, Instant Messaging, Laws, Lifecycle development, Linux, MySQL, Network monitoring, Network protocols, Networking, Outsourcing, Regulations, Spam, standards, Training, Web development
OVRDBF in JAVA
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
Answer Question
| November 25, 2009 6:25 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
Answer Question
| November 25, 2009 6:25 AM
Application development, AS/400, CLP, DataCenter, DB2 Universal Database, Printing, RPG, RPGLE, Security, Web development
AMD vs. Intel: Data Warehouse Servers and Consolidated Database Servers …
Hello everyone, Hope all is well … Any help, opinions, direction to whitepapers, benchmarch reports, overkill/underkill comments, and the like would be greatly appreciated: We are in the process of spec’ing out hardware needs for our targeted new data warehouse and new consolidated database servers. We would like any comparative views regarding AMD vs. Intel [...]
Answer Question
| January 25, 2006 6:12 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
Hello everyone, Hope all is well … Any help, opinions, direction to whitepapers, benchmarch reports, overkill/underkill comments, and the like would be greatly appreciated: We are in the process of spec’ing out hardware needs for our targeted new data warehouse and new consolidated database servers. We would like any comparative views regarding AMD vs. Intel [...]
Answer Question
| January 25, 2006 6:12 PM
Database, DB2, Desktops, Management, Microsoft Windows, Oracle, OS, Security, Servers, SQL, SQL Server
OVRDBF in Java
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
Answer Question
| November 25, 2009 11:47 PM
Application development, AS/400, CLP, DB2 Universal Database, Java
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
Answer Question
| November 25, 2009 11:47 PM
Application development, AS/400, CLP, DB2 Universal Database, Java
Query Regarding Crystal Reports
Hi, I need to produce a flat file in fixed length format as output of Crystal Report. Wanted to know if crystal report supports exporting data into a Flat file fixed lenght format. If yes, would like to know how to go about it.
Answer Question
| January 13, 2010 5:23 PM
Business/IT alignment, Database, DB2, Development, Oracle
Hi, I need to produce a flat file in fixed length format as output of Crystal Report. Wanted to know if crystal report supports exporting data into a Flat file fixed lenght format. If yes, would like to know how to go about it.
Answer Question
| January 13, 2010 5:23 PM
Business/IT alignment, Database, DB2, Development, Oracle
Move from DB2/400 flat-file system to Oracle
Rao wrote in with this question recently: “We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the Metamodel(total DDL scripts) from DB2/400 and go for data modeling. Initially, I thought Oracle Migration Work Bench (OMWB)would work. Unfortunately, it does not [...]
Answer Question
| January 23, 2006 11:00 AM
DB2 Universal Database
Rao wrote in with this question recently: “We are planning to move from a DB2/400 flat-file system to Oracle. We do not have any relations in DB2/400. I want to extract the Metamodel(total DDL scripts) from DB2/400 and go for data modeling. Initially, I thought Oracle Migration Work Bench (OMWB)would work. Unfortunately, it does not [...]
Answer Question
| January 23, 2006 11:00 AM
DB2 Universal Database
Problems copying from a PF to a XML file using CPYTOIMPF
Sanjeev wrote in with this question recently: “We are trying to copy from a PF to a XML file using CPYTOIMPF using STMFCODPAG(*PCASCII). The copy is not consistent — sometimes it works fine and sometime it doesn?t.” Do you have any suggestions that might help him out? – Debra Tart, associate editor, Search400.com
Answer Question
| January 23, 2006 10:51 AM
DB2 Universal Database
Sanjeev wrote in with this question recently: “We are trying to copy from a PF to a XML file using CPYTOIMPF using STMFCODPAG(*PCASCII). The copy is not consistent — sometimes it works fine and sometime it doesn?t.” Do you have any suggestions that might help him out? – Debra Tart, associate editor, Search400.com
Answer Question
| January 23, 2006 10:51 AM
DB2 Universal Database
Selecting and inserting library names
Jeremy wrote in with this question recently: “Within an /exec SQL statement, I want to select from a file in one library and insert into the same file in a second. How should I refer to the library names? The editor rejects my attempts to refer to the libraries as host variables as per the [...]
Answer Question
| January 24, 2006 10:47 AM
DB2 Universal Database
Jeremy wrote in with this question recently: “Within an /exec SQL statement, I want to select from a file in one library and insert into the same file in a second. How should I refer to the library names? The editor rejects my attempts to refer to the libraries as host variables as per the [...]
Answer Question
| January 24, 2006 10:47 AM
DB2 Universal Database
Is there an IBM Tool to Rebind Plans/Collections
I am an applicaiton developer, (analyst) resonsible for ensuring four test regions (and sometimes the produciton region) performs as effieciently as possible. We have approximately 1000 programs that have not accurate statistics (run stats are not updated, another question). Our DBA’s tell us it is our responsibility to rebind the applicaitons (one at a time) [...]
Answer Question
| January 20, 2006 5:36 PM
390, Database, DB2, Mainframe, Oracle
I am an applicaiton developer, (analyst) resonsible for ensuring four test regions (and sometimes the produciton region) performs as effieciently as possible. We have approximately 1000 programs that have not accurate statistics (run stats are not updated, another question). Our DBA’s tell us it is our responsibility to rebind the applicaitons (one at a time) [...]
Answer Question
| January 20, 2006 5:36 PM
390, Database, DB2, Mainframe, Oracle
